[DERBY-1489] Provide ALTER TABLE DROP 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
• Urgency: Normal
• Assignee: Bryan Pendleton
• Reporter: Bryan Pendleton
• Created: 08/Jul/06 23:16
• Updated: 01/Jul/09 00:34
• Resolved: 05/Oct/06 23:15

Description

Provide a way to drop a column from an existing table. Possible syntax would be:

ALTER TABLE tablename DROP COLUMN columnname CASCADE / RESTRICT;

Feature should properly handle columns which are used in constraints, views, triggers, indexes, etc.

Issue Links

• is blocked by: DERBY-1583 With grant revoke enabled, defining a trigger whose actions updates a table (from different schema) results in NPE
• is blocked by: DERBY-1754 sqlAuthorization mode causes Null Pointer Exception during ALTER TABLE
• is blocked by: DERBY-1847 SELECT statement asserts with XJ001 when attempted to select a newly added column in SQL authorization mode
• is depended upon by: DERBY-1926 Provide documentation for ALTER TABLE DROP COLUMN
• is related to: DERBY-1854 SYSCS_COMPRESS_TABLE corrupts table with a single column which is both a primary key and a foreign key
• is related to: DERBY-1847 SELECT statement asserts with XJ001 when attempted to select a newly added column in SQL authorization mode
• relates to: DERBY-1909 ALTER TABLE DROP COLUMN needs to update GRANTed column privileges
• relates to: DERBY-3940 Dropping a column does not drop triggers which mention that column
• relates to: DERBY-396 Support for ALTER STATEMENT to DROP , MODIFY, RENAME a COLUMN
• relates to: DERBY-726 How can i drop one column?
• relates to: DERBY-165 Droppping columns with ALTER TABLE errors out