22,209
社区成员
发帖
与我相关
我的任务
分享
有外健關系時用級聯刪除
create table T(ID int unique)
create table T22 (ID int references T(ID) on delete cascade)
create table T33 (ID int references T(ID) on delete cascade)
create trigger tr_tb_d on tb for delete
as
delete tb1 from tb1,deleted where tb1.keycol = deleted.keycol