建表时的常见约束

create table student
(
sid number primary  key,/*主键约束*/
cid number references course(cid),/*外键约束*/
sname varchar(20) not null,/* 不为空*/
sex char(2) check(sex='男'or sex='女')/*有一个条件为真*/
birthday date,
snation varchar(10) default '汉'
)
create table course
(
cid nunmber primary key,
cname varchar2(10) unique/*列的唯一性约束，可以为空*/
)
对应的表级约束：
CONSTRAINT stu_id_pk PRIMARY KEY(sid);
CONSTRAINT stu_cid_fk FOREIGN KEY (cid)
REFERENCES course(cid),
CONSTRAINT stu_sex_c CHECK (sex='男' or sex='女'),
CONSTRAINT course_cname_uk UNIQUE(cname);
*not null不能定义表级约束