Alter Null Column to not null with default value

guptae

Hi All,

I want to alter nullable column to not null with default .
I have a table employee it contain some col

Emp-Depart char(16) ;

want to change it to
Emp-Depart char(16) not null with default 'training';

One way it to add constraint
ALTER TABLE <TABLENAME> ADD CONSTRAINT NULL_FIELD CHECK (<FIELD> IS NOT
NULL)

But it will not contain default value...

Please advise.

guptae · Posted: Thu Oct 09, 2008 6:45 pm Post subject:

Hello All,

Just to add that we are using db2v8.