to change not null constraint to null

ugna04@yahoo.com · New User Joined: 25 Sep 2005 Posts: 3

i have created a table
create table emp(eid varchar(4) not null primary key,ename char(10) not null,age integer,deptid varchar(4) not null) ;
now i want to alter this table to change the not null value of ename to
null ,how would i write the necessary sql statement for it.
please clear my doubt.

SWAPNA LATHA · New User Joined: 13 Jun 2005 Posts: 3

hi,

check this syntax...i dint try this

alter table emp modify ename char(10);
(default is null)

or

alter table emp modify (ename char(10) not null to ename char(10) null);