[ http://issues.apache.org/jira/browse/DERBY-168?page=all ]
Jeff Levitt updated DERBY-168:
------------------------------
Attachment: derby168.diff
This derby168.diff patch removes the references decribed in the ALTER TABLE
description. If the code for doing this is contributed later on, we can always
re-insert the descriptions.
> 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
> 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
