实体完整性实验
在列级定义实体完整性:
CREATE TABLE Student(Sno CHAR(9) PRIMARY KEY,Sname CHAR(20) UNIQUE,Ssex CHAR(2),Sage SMALLINT, Sdept CHAR(20));
在表级定义实体完整性:
Create table SC(Sno char(9),Cno char(4),Grade Smallint,primary key(Sno,Cno),foreign key(Sno) references Student(Sno),foreign key (Cno) references Course(Cno));
创建表后添加完整性约束
alter table book add constraint pkey primary key(bno);
查看约束
SELECT * FROM information_schema.TABLE_CONSTRAINTS
where table_name=‘book’;