guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
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. |
|