create trigger Delete_sc on student for delete as delete student_course where student_course.s_no in(select s_no from deleted)
student表中创建触发器，实现student表和student _course表的级联删除
原文：http://www.cnblogs.com/tk55/p/6084061.html
