2.2.8.sql

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

 USE school
alter table choices drop [FK_CHOICES_STUDENTS];
alter table choices add 
CONSTRAINT [FK_CHOICES_STUDENTS] FOREIGN KEY 
	(
		[sid]
	) REFERENCES [dbo].[STUDENTS] (
		[sid]
	)on delete cascade;
delete from students where sid='800001216';
select * from stu_card;
select * from icbc_card;