Unity复习之键的约束

欢迎大家来到我的博客http://unity.gopedu.com/home.php?mod=space&uid=3352&do=blog&view=me&from=space

给表添加键的约束

--增加一列

alter table teacher add age int null

alter table users add age int null

 

--更改列类型

alter table teacher alter column age varchar(3)

alter table users alter column age varchar(3)

 

--删除一列

alter table teacher drop column age

alter table users drop column age

 

--为teacher表添加主键约束

alter table teacher add constraint t_pk primary key(id)

 

--为teacher表的name添加唯一约束

alter table teacher add constraint t_un unique(name)

 

--为teacher表的sex添加默认约束

alter table teacher add constraint t_de default('男') for sex

insert into teacher(id,name) values(101,'aa')

 

--为teacher表的age添加检查约束

alter table teacher add constraint t_ch check(age>=15 and age<=40)

insert into teacher(id,name,age) values(102,'bb',50)

 

--为teacher和users表添加主外关联

alter table score add constraint t_fk foreign key(uid) references users(id)

 

insert into score(id,grade,uid) values(1,85,110)

 

--删除约束

alter table score drop constraint t_fk

请继续关注我的博客

http://unity.gopedu.com/home.php?mod=space&uid=3352&do=blog&view=me&from=space

更多精彩尽在http://www.gopedu.com/