[DERBY-1490] Provide ALTER TABLE RENAME COLUMN functionality

• 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.3.1.4
• Component/s: Documentation, SQL
• Assignee: Bryan Pendleton
• Reporter: Bryan Pendleton
• Created: 08/Jul/06 23:23
• Updated: 02/May/13 02:29
• Resolved: 09/Nov/06 00:03

Description

Provide a way to rename a column in an existing table. Possible syntax could be:

ALTER TABLE tablename RENAME COLUMN oldcolumn TO newcolumn;

Feature should properly handle the possibility that the column is currently used in constraints, views, indexes, triggers, etc.

Issue Links

• is depended upon by: DERBY-2042 Provide documentation for new RENAME COLUMN statement
• is related to: DERBY-2041 Trigger should register a dependency on tables and columns used in its body
• 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