1、create table student
( sid varchar(10),
cid varchar(15) not null, sname varchar(15), sex varchar(4), score int,
idcode varchar(20),
constraint pk_s primary key(sid) )
2、alter table student drop constraint PK_s go
alter table student
add constraint pk_s1 primary key clustered(sid,cid) 3、alter table student
add constraint pk_s2 unique(idcode)
4、alter table student
add constraint pk_s3 check(score>=0 and score<=150) 5、alter table student
add constraint pk_s4 foreign key(sid) references stuinfo(sid)
6、alter table student
add constraint pk_s5 default('男') for sex 7、create rule ru1 as
@a like '0[1,2]%' go
exec sp_bindrule 'ru1','student.cid'