db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: alter nullability with 10.2
Date Fri, 17 Nov 2006 16:49:27 GMT
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


Mime
View raw message