You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Satheesh Bandaram (JIRA)" <de...@db.apache.org> on 2005/03/09 06:51:53 UTC
[jira] Updated: (DERBY-165) Droppping columns with ALTER TABLE errors out
[ 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
Re: [jira] Updated: (DERBY-165) Droppping columns with ALTER TABLE
errors out
Posted by Jeremy Boynes <jb...@apache.org>.
Danesh Irani wrote:
> Is "alter table drop column" part of the standard?
>
It is an optional feature in SQL-1999 and on.
--
Jeremy
Re: [jira] Updated: (DERBY-165) Droppping columns with ALTER TABLE
errors out
Posted by Edward Rayl <er...@bellsouth.net>.
Danesh Irani wrote:
>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
>
>
Oracle has been able to do this for a while. When telling customers they
could do this (for the first time), I got cheers. The rules for drop
column are complex however. See:
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_3001.htm#sthref3626
Re: [jira] Updated: (DERBY-165) Droppping columns with ALTER TABLE errors out
Posted by Danesh Irani <da...@gmail.com>.
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)
<de...@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
>
>