这明显是外键的功能吗,使用on delete cascade,比如: ALTER TABLE CITY ADD CONSTRAINT FK_STATE FOREIGN KEY (COUNTRY_CODE, STATE_CODE) REFERENCES STATE (COUNTRY_CODE, STATE_CODE) ON DELETE CASCADE; 不过trigger也不以完成的,只不过是不对truncate触发。 CREATE OR REPLACE TRIGGER policy_who AFTER delete ON pri_table_name FOR EACH ROW BEGIN delete from sla_table_name where col1=:old.col1; END
ALTER TABLE CITY ADD CONSTRAINT FK_STATE
FOREIGN KEY (COUNTRY_CODE, STATE_CODE)
REFERENCES STATE (COUNTRY_CODE, STATE_CODE)
ON DELETE CASCADE; 不过trigger也不以完成的,只不过是不对truncate触发。
CREATE OR REPLACE TRIGGER policy_who AFTER delete
ON pri_table_name
FOR EACH ROW
BEGIN
delete from sla_table_name where col1=:old.col1;
END