[ http://issues.apache.org/jira/browse/DERBY-168?page=all ] Jeff Levitt closed DERBY-168: -----------------------------
Fixed in 10.1.0.0 > Can't ALTER a column to have a new DEFAULT value. > ------------------------------------------------- > > Key: DERBY-168 > URL: http://issues.apache.org/jira/browse/DERBY-168 > Project: Derby > Type: Bug > Components: Documentation > Versions: 10.0.2.0 > Environment: Windows XP SP1 Professional > Reporter: George Baklarz > Priority: Minor > Fix For: 10.1.0.0 > Attachments: derby168.diff > > Documentation states that an existing column in a table can have a DEFAULT > value added via the ALTER TABLE statement. Unfortunately, none of the syntax > provided gives a way of accomplishing this. An equivalent command from DB2 > would be: > ALTER TABLE EMPL ALTER COLUMN BONUS SET DEFAULT 1000; > Is this an error in the documentation, and omission in the product, or is > there a different command to accomplish this? -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
