[DERBY-396] Support for ALTER STATEMENT to DROP , MODIFY, RENAME a COLUMN

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 10.3.1.4
• Component/s: SQL
• Environment: LINUX
• Assignee: Bryan Pendleton
• Reporter: Kumar Matcha
• Created: 28/Jun/05 21:12
• Updated: 01/Jul/09 00:34
• Resolved: 17/Nov/06 22:32

Description

Alter Statement should support dropping a column, modifying a column to a different data type , rename a column.

Issue Links

• is cloned by: DERBY-726 How can i drop one column?
• is related to: DERBY-1909 ALTER TABLE DROP COLUMN needs to update GRANTed column privileges
• is related to: DERBY-1489 Provide ALTER TABLE DROP COLUMN functionality
• is related to: DERBY-1490 Provide ALTER TABLE RENAME COLUMN functionality
• is related to: DERBY-1491 Provide ALTER TABLE functionality to change a column's default value
• is related to: DERBY-1492 Provide ALTER TABLE functionality to change a column from NULL to NOT NULL or vice versa
• is related to: DERBY-1515 Provide ALTER TABLE functionality to change a column's data type
• relates to: DERBY-168 Can't ALTER a column to have a new DEFAULT value.
• relates to: DERBY-119 Add ALTER TABLE option to change column from NULL to NOT NULL
• relates to: DERBY-1490 Provide ALTER TABLE RENAME COLUMN functionality
• relates to: DERBY-1491 Provide ALTER TABLE functionality to change a column's default value
• relates to: DERBY-1492 Provide ALTER TABLE functionality to change a column from NULL to NOT NULL or vice versa
• relates to: DERBY-165 Droppping columns with ALTER TABLE errors out
• relates to: DERBY-1515 Provide ALTER TABLE functionality to change a column's data type