create table a(aa int primary key); create table b(bb int references a(aa)); insert into a values(1); insert into b values(1); go
create trigger tri_delete_a on a instead of delete as begin declare @abc int; select @abc = aa from deleted; delete b where bb = @abc; delete a where aa = @abc; end