| Key: |
DERBY-168
|
| Type: |
Bug
|
| Status: |
Closed
|
| Resolution: |
Fixed
|
| Priority: |
Minor
|
| Assignee: |
Unassigned
|
| Reporter: |
George Baklarz
|
| Votes: |
0
|
| Watchers: |
0
|
|
If you were logged in you would be able to see more operations.
|
|
|
|
File Attachments:
|
|
|
Environment:
|
Windows XP SP1 Professional
|
|
Issue Links:
|
Reference
|
|
|
|
This issue is related to:
|
|
DERBY-396
Support for ALTER STATEMENT to DROP , MODIFY, RENAME a COLUMN
|
|
|
|
|
|
|
| Resolution Date: |
12/May/05 03:18 AM
|
|
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?
|
|
Description
|
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? |
Show » |
|
Can't ALTER a column to have a new DEFAULT value.
