1. 触发器方法create Trigger Trigger_Name on Table1
after delete,UPDATE
as
begin
set nocount on;
if exists(select * from inserted)
update Table2 set field1 = (select field1 from inserted) where field1 = (select field1 from inserted)
else
delete from Table2 where field1 = (select field1 from deleted)
set nocount off;
end
2. 创建外键关联关系ALTER TABLE table1 ADD CONSTRAINT [FK_Table1_Table2] FOREIGN KEY(field1) REFERENCES table2 (field1) ON UPDATE CASCADE ON DELETE CASCADE