大家帮我，给个触发器的例子，我找了很久斗没有找到

[tian_wj]

就做个最简单的吧：table1,table2,在table1上删除记录的时候把

table2中有相同id关联的记录一起删除掉，谢谢，

[dragonerfish]

身边没有,晚些时候给你!!!

[llzczf]

TRIGGER bf_change_line
before insert on change_line
for each row
declare max_no varchar2(16);
c_proc varchar2(6); /*外勘时环节*/
bool1 integer;
count1 integer;
begin
update sheet_manage
set sheet_statu = 4
where ask_id = :new.ask_id;
select max(num)
into :new.num
from exec_order
where ask_id = :new.ask_id;
IF ltrim(:NEW.user_flag) is null THEN
:new.user_flag := '1';
END IF;
end ;

[zhongzengkun]

我给你最详细的例子，能给我加几分呀。

[am2000]

我也想要啊！

[m_shmily]

CREATE TRIGGER TR_TABLE2_BD_RDOW
BEFORE DELETE ON TABLE1
FOR EACH ROW
BEGIN
DELETE FROM TABLE2 WHERE ID=:NEW.ID;
END;
/

[yangzi]

sql server的例子如下：
CREATE trigger tt
on talbe1
for delete
as
delete table2 where id = deleted.id