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'
>DB2 'Alter table drop column' equals 'drops and re-creates the table'
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:


View raw message