[ http://issues.apache.org/jira/browse/DERBY-165?page=comments#action_62028 ] Petr Jiricka commented on DERBY-165: ------------------------------------
I also miss the ability to drop columns in Derby. > Droppping columns with ALTER TABLE errors out > --------------------------------------------- > > Key: DERBY-165 > URL: http://issues.apache.org/jira/browse/DERBY-165 > Project: Derby > Type: New Feature > Components: SQL > Environment: Linux > Reporter: Shreyas Kaushik > Priority: Minor > > 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------------------------------------------- -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira
