[DERBY-165] Droppping columns with ALTER TABLE errors out

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Duplicate
• Component/s: SQL
• Environment: Linux
• Assignee: Unassigned
• Reporter: Shreyas
• Created: 07/Mar/05 19:17
• Updated: 01/Jul/09 00:34
• Resolved: 24/Jan/06 05:53

Description

When I try to drop columns using ALTER TABLE command I get the following error, irrespective of me using "column" keyword in addition to the drop keyword.

---------------------ERROR REPORT------------------------------------------
ij> alter table test_linux drop column dept;
ERROR 42X01: Syntax error: Encountered "drop" at line 1, column 24.
ij> alter table test_linux drop dept;
ERROR 42X01: Syntax error: Encountered "drop" at line 1, column 24.
---------------------ERROR REPORT------------------------------------------

Issue Links

• is related to: DERBY-396 Support for ALTER STATEMENT to DROP , MODIFY, RENAME a COLUMN
• is related to: DERBY-1489 Provide ALTER TABLE DROP COLUMN functionality