Trigger

TITEL_DEL

Beschreibung

Löscht alle anderen Fremdschlüsselbeziehungen.

Definition

CREATE TRIGGER TITEL_DEL FOR TITEL
ACTIVE BEFORE DELETE POSITION 0
AS
BEGIN
  DELETE FROM GRUPPENTITEL WHERE OLD.TIID = GRUPPENTITEL.GTTIID;
  DELETE FROM TITELPERSONEN WHERE OLD.TIID = TITELPERSONEN.TPTIID;
  DELETE FROM STICHWORTINDEXE WHERE OLD.TIID = STICHWORTINDEXE.SITIID;
  DELETE FROM WORTINDEXE WHERE OLD.TIID = WORTINDEXE.WITIID;
  DELETE FROM TITELTRAEGER WHERE OLD.TIID = TITELTRAEGER.TTTIID;
  DELETE FROM MUSIKDETAIL WHERE OLD.TIID = MUSIKDETAIL.MDTIID;
  DELETE FROM MARKER WHERE OLD.TIID = MARKER.MATIID;
  DELETE FROM UNTERTITEL WHERE (OLD.TIID = UNTERTITEL.UTTIID) OR (OLD.TIID = UNTERTITEL.UTTIIDUNTER);
  DELETE FROM TITEL_ATTRIBUTE WHERE OLD.TIID = TITEL_ATTRIBUTE.TATIID;
  DELETE FROM ZUSATZFELD WHERE OLD.TIID = ZUSATZFELD.ZUTIID;
  DELETE FROM GELESEN WHERE OLD.TIID = GELESEN.GLTIID;
  DELETE FROM TITEL_FAECHER_LINK WHERE OLD.TIID = TITEL_FAECHER_LINK.TFLTIID;
END