alter table rl_ks add constraint fk_rl_ks foreign key(bmh) references rl_bm(bmh) on delete cascade go
CREATE TRIGGER double_delete ON rl_bm FOR DELETE AS BEGIN
delete rl_ks where bmh in (select b.bmh from deleted b) END GO
先创建触发器 create trigger tri_del on rl_bm for delete as begin delete rl_ks where rl_ks.bmh=deleted.bmh end然后删除r1_bm中的记录。 我觉得rl_ks表的外键和rl_bm表一定相同。另外我认为应该使用级联删除更好。
on delete cascade
go
ON rl_bm
FOR DELETE
AS
BEGIN
delete rl_ks
where bmh in
(select b.bmh
from deleted b)
END
GO
create trigger tri_del
on rl_bm
for delete
as
begin
delete rl_ks
where rl_ks.bmh=deleted.bmh
end然后删除r1_bm中的记录。
我觉得rl_ks表的外键和rl_bm表一定相同。另外我认为应该使用级联删除更好。