Trigger

TITEL_DEL_EASY_PLAN

Beschreibung

Löscht die Fremdschlüsselbeziehung zu den Easy Plan Tabellen.

Definition

CREATE TRIGGER TITEL_DEL_EASY_PLAN FOR TITEL
ACTIVE BEFORE DELETE POSITION 1
AS
BEGIN
  DELETE FROM TITEL_KATEGORIE WHERE OLD.TIID = TITEL_KATEGORIE.TKTIID;
  DELETE FROM TITEL_MERKMAL_ATTRIBUT WHERE OLD.TIID = TITEL_MERKMAL_ATTRIBUT.TMTIID;
END