触发器

在删除表1的某条记录之后,删除表2与之相关的数据

CREATE OR REPLACE TRIGGER tr_del AFTER DELETE ON 表1 REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW ENABLE

BEGIN

delete from 表2 where 表2字段 = :OLD.表1字段;

END;

备注:会忽略主外键关系

posted @ 2017-05-02 11:51  温柔牛  阅读(98)  评论(0编辑  收藏  举报