用触发器应该可以实现例如:sc表中引用了student表的字段sid作为外键,如果要求在删除student表的一条记录的同时,也要删除sc表中相应的纪录,则可写一个触发器来实现Create TRIGGER [DeleteTrigger] ON [dbo].[student] AFTER deleteAS BEGIN SET NOCOUNT ON; delete from sc from deleted where sc.sid=deleted.sidEND