[DERBY-1491] Provide ALTER TABLE functionality to change a column's default value

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.1.2.1, 10.1.3.1, 10.2.1.6
• Fix Version/s: 10.2.2.0, 10.3.1.4
• Component/s: Documentation, SQL
• Issue & fix info: Release Note Needed
• Assignee: Bryan Pendleton
• Reporter: Bryan Pendleton
• Created: 08/Jul/06 23:26
• Updated: 02/May/13 02:28
• Resolved: 23/May/07 01:15

Description

Provide a way to alter the default value for an existing column in an existing table. The syntax should probably some variant of the ALTER TABLE statement.

Issue Links

• is depended upon by: DERBY-1765 Update ALTER TABLE documentation to reflect DERBY-119 (ALTER COLUMN [NOT]NULL)
• is related to: DERBY-396 Support for ALTER STATEMENT to DROP , MODIFY, RENAME a COLUMN
• relates to: DERBY-396 Support for ALTER STATEMENT to DROP , MODIFY, RENAME a COLUMN