Re: alter nullability with 10.2

[Rick Hillegas]

Bob Durie wrote:
Hi - the new derby claims support for altering the nullability of a 
column.  Anyone know what the new alter table syntax is to do this?
Hi Bob,
The sytax is

ALTER TABLE tableName ALTER COLUMN columnName NULL

or

ALTER TABLE tableName ALTER COLUMN columnName NOT NULL

For details, please see the ALTER TABLE section of the Derby Reference 
Guide.

Regards,
-Rick