帮助，帮助，关于触发器的编写？？？？？（在线等！！！！！急急急）

[zm12345]

我有两个表，其ID号为统一编号，如何写一触发器，当删除表一内的某条记录时，同时也删除表二内同一编号的记录》？？？？




急急！！！！！

[penitent]

owlbirdwill()还是sql server的语法
KingSunSha(弱水三千)的可以

[ATCG]

这用级联删除也可以实现
create table aa
(id number(5) primary key,
name varchar2(8));

create table bb
(id number(5) primary key references aa(id) on delete cascade);

当delete from aa时,在表bb中相应的记录也被同时删除.

[KingSunSha]

create trigger tb1_after_delete
after delete on tb1
for each row
begin
delete tb1 where id= :old.id;
end;
/

[owlbirdwill]

create trigger delbiao12
on biao1
for delete
as
delete biao2
where id=deleted.id