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
