Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    3

    Unanswered: Unable to set DEAFULT column value

    I know this is probably a ridiculous problem, but unfortunately I can't seem to alter an existing column and set a default value to '0'.

    Any feedback would be much appreciated!

    Thanks,
    Kimberly

  2. #2
    Join Date
    Feb 2003
    Location
    Milano, Italy
    Posts
    80
    That's because the default value is not a column property but a constraint.

    You have to use the ALTER TABLE ... ADD CONSTRAINT statement
    Davide Mauri
    http://www.davidemauri.it

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •