SQL之约束

 

ALTER TABLE student add constraint def_ssex default  '男'  FOR  ssex

ALTER TABLE student add constraint che_sdept check (sdept in('CS','MA','IS'))            //check后面是布尔表达式

alter table student add constraint uni_sname unique(sname)

alter table sc add constraint fk_S_c foreign key(sno) references student(sno)

 

临时关闭约束:  alter table student NOCHECK constraint che_sdept

重新打开约束：alter table student CHECK constraint che_sdept

删除约束：       altertable student drop constraint che_sdept