Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    7

    Question Unanswered: Adding a default value through Alter table statement

    Is it possible to add a default value for a column through the alter table command?Please reply

    regards
    Shrini

  2. #2
    Join Date
    Nov 2003
    Location
    Germany
    Posts
    62
    I can only speak for DB2 z/OS: No, you have to drop and recreate the table.

  3. #3
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You cannot do it for UDB for LUW either. You have to use the same method.

    Andy

Posting Permissions

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