触发器实现级联删除,tb_Grade表中的外键是the_Course表中的主键。
create trigger tri_CG
on tb_Grade
after delete
as
delete from tb_Course
where CourseID=(select CourseID from deleted)
go
delete from tb_Grade
where CourseID='1001'
go
触发器实现级联删除,tb_Grade表中的外键是the_Course表中的主键。
create trigger tri_CG
on tb_Grade
after delete
as
delete from tb_Course
where CourseID=(select CourseID from deleted)
go
delete from tb_Grade
where CourseID='1001'
go