[ http://issues.apache.org/jira/browse/DERBY-165?page=all ]
Kristian Waagan closed DERBY-165. --------------------------------- Closing this duplicate issue. For general information about ALTER TABLE consult DERBY-396. For details about ALTER TABLE DROP COLUMN, see DERBY-1489. > Droppping columns with ALTER TABLE errors out > --------------------------------------------- > > Key: DERBY-165 > URL: http://issues.apache.org/jira/browse/DERBY-165 > Project: Derby > Issue 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 - For more information on JIRA, see: http://www.atlassian.com/software/jira
