student表中创建触发器,实现student表和student _course表的级联删除

create trigger Delete_sc
on student
for delete
as
delete student_course where student_course.s_no in(select s_no from deleted)

 

posted on 2016-11-21 00:01  Honey_Badger  阅读(2724)  评论(0编辑  收藏  举报

导航

github