db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Danesh Irani <danes...@gmail.com>
Subject Re: [jira] Updated: (DERBY-165) Droppping columns with ALTER TABLE errors out
Date Wed, 09 Mar 2005 06:09:57 GMT
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)
<derby-dev@db.apache.org> 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
> 
>

Mime
View raw message