Anonymous
public sql v1 · immutable CREATE OR REPLACE TRIGGER track_delete_trigger BEFORE DELETE ON ic03jc.album REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN DELETE FROM ic03jc.album_track WHERE dbalbumid = :OLD.dbalbumid; END; CREATE OR REPLACE TRIGGER track_delete_trigger BEFORE DELETE ON ic03jc.album REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN DELETE FROM ic03jc.album_track WHERE dbalbumid = :OLD.dbalbumid; END;