2.2.2.sql

来自「清华大学出版社出版的数据库系统教程附带的实验教程中所有的源代码」· SQL 代码 · 共 13 行

USE SCHOOL
CREATE TABLE SC(
sno CHAR(5) REFERENCES Stu_Union (sno) on delete cascade,
cno CHAR(4) REFERENCES Course(cno) on delete cascade,
grade INT,
CONSTRAINT PK_SC PRIMARY KEY (sno,cno)
);
insert into sc values ('95002','0001',2);
insert into sc values ('95002','0002',2);
insert into sc values ('10001','0001',2);
insert into sc values ('10001','0002',2);
Select * From SC;