oracle - how to modify a constraint in sql plus? -
i have created table follows:
create table emp( emp_id number(5) primary key , emp_name varchar(20) not null , dob date ); after table has been created how change constraint not null unique or other constraint in sql*plus?
you don't change constraint 1 type another. can add unique constraint table
alter table emp add ( costraint uk_emp_name unique( emp_name ) ); that independent of whether emp_name allowed have null values.
Comments
Post a Comment