Is "alter table drop column" part of the standard? I know db2 dosent allow you to drop columns...DB2 Basic CLI 'Alter table' http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.udb.doc/admin/r0000888.htm
DB2 'Alter table drop column' equals 'drops and re-creates the table' http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.udb.doc/core/c0011640.htm Cheers, ~Danesh On Wed, 9 Mar 2005 06:51:53 +0100 (CET), Satheesh Bandaram (JIRA) <[email protected]> wrote: > [ http://issues.apache.org/jira/browse/DERBY-165?page=history ] > > Satheesh Bandaram updated DERBY-165: > ------------------------------------ > > type: New Feature (was: Bug) > > I believe this is a new feature request. Derby reference manual doesn't > describe drop column. > http://incubator.apache.org/derby/manuals/reference/sqlj26.html#HDRSII-SQLJ-81859 > > > 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 > >
