db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: ALTER TABLE changes in 10.2.1.3
Date Fri, 08 Sep 2006 21:05:51 GMT
Stephen Caine wrote:
> Is dropping a column now supported in 10.2.1.3?

Hi Stephen, thanks for trying the beta!

The ALTER COLUMN changes in this beta are DERBY-119 and DERBY-1491,
which allow you to do:

   ALTER TABLE t ALTER COLUMN c [ NOT ] NULL
      This lets you add or remove the NOT NULL constraint on a column
   ALTER TABLE t ALTER COLUMN c [ WITH ] DEFAULT default-value
      This lets you change the default value for a column

Dropping a column is DERBY-1489, which is getting closer to being
ready to commit, but is not there yet.

You might want to register yourself as a "watcher" on DERBY-1489
to keep better track on its progress:
http://issues.apache.org/jira/browse/DERBY-1489

thanks,

bryan



Mime
View raw message