db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edward Rayl <er...@bellsouth.net>
Subject Re: [jira] Updated: (DERBY-165) Droppping columns with ALTER TABLE errors out
Date Wed, 09 Mar 2005 13:45:37 GMT
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



Mime
View raw message