Back to OIM Explorer

dbo.DPR_TDDPRSystemObjectMatchSets

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on DPRSystemObjectMatchSets. Trigger parent table: DPRSystemObjectMatchSets

Source: sandbox-db sys.sql_modules

Source size: 1.216 characters

Interpretation

  • Database trigger. Treat parent table and enqueue/object-layer calls as the main relation points.

Relations

  • Trigger parent table: DPRSystemObjectMatchSets

Typed Edges

  • trigger on table DPRSystemObjectMatchSets Trigger parent table: DPRSystemObjectMatchSets
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL61 lines
1CREATE trigger DPR_TDDPRSystemObjectMatchSets2  ON DPRSystemObjectMatchSets FOR3DELETE NOT FOR replication4AS5BEGIN6  BEGIN TRY7    IF EXISTS(8      SELECT TOP 1 19      FROM deleted d10      WHERE11        d.UID_DifferenceLeftToRightSet > ' ')12    BEGIN13      DELETE DPRSystemObjectMatchSet14      FROM DPRSystemObjectMatchSet x15      JOIN deleted d16        ON x.UID_DPRSystemObjectMatchSet = d.UID_DifferenceLeftToRightSet17    END18    IF EXISTS(19      SELECT TOP 1 120      FROM deleted d21      WHERE22        d.UID_DifferenceRightToLeftSet > ' ')23    BEGIN24      DELETE DPRSystemObjectMatchSet25      FROM DPRSystemObjectMatchSet x26      JOIN deleted d27        ON x.UID_DPRSystemObjectMatchSet = d.UID_DifferenceRightToLeftSet28    END29    IF EXISTS(30      SELECT TOP 1 131      FROM deleted d32      WHERE33        d.UID_IntersectionDifferenceSet > ' ')34    BEGIN35      DELETE DPRSystemObjectMatchSet36      FROM DPRSystemObjectMatchSet x37      JOIN deleted d38        ON x.UID_DPRSystemObjectMatchSet = d.UID_IntersectionDifferenceSet39    END40    IF EXISTS(41      SELECT TOP 1 142      FROM deleted d43      WHERE44        d.UID_IntersectionEqualitySet > ' ')45    BEGIN46      DELETE DPRSystemObjectMatchSet47      FROM DPRSystemObjectMatchSet x48      JOIN deleted d49        ON x.UID_DPRSystemObjectMatchSet = d.UID_IntersectionEqualitySet50    END51  END TRY52  BEGIN CATCH53    EXEC QBM_PSessionErrorAdd DEFAULT54    RAISERROR('',55    18,56    1)57      WITH NOWAIT58  END CATCH59  ende:60  RETURN61END
Open raw exported source
SQL ยท Raw9 lines
1 create   trigger DPR_TDDPRSystemObjectMatchSets on DPRSystemObjectMatchSets  for delete not for replication as begin  BEGIN TRY if exists (select2 top 1 1 from deleted d where d.UID_DifferenceLeftToRightSet > ' ' ) begin delete DPRSystemObjectMatchSet from DPRSystemObjectMatchSet x join deleted d3 on x.UID_DPRSystemObjectMatchSet = d.UID_DifferenceLeftToRightSet end if exists (select top 1 1 from deleted d where d.UID_DifferenceRightToLeftSet > 4' ' ) begin delete DPRSystemObjectMatchSet from DPRSystemObjectMatchSet x join deleted d on x.UID_DPRSystemObjectMatchSet = d.UID_DifferenceRightToLeftSet5 end if exists (select top 1 1 from deleted d where d.UID_IntersectionDifferenceSet > ' ' ) begin delete DPRSystemObjectMatchSet from DPRSystemObjectMatchSet6 x join deleted d on x.UID_DPRSystemObjectMatchSet = d.UID_IntersectionDifferenceSet end if exists (select top 1 1 from deleted d where d.UID_IntersectionEqualitySet7 > ' ' ) begin delete DPRSystemObjectMatchSet from DPRSystemObjectMatchSet x join deleted d on x.UID_DPRSystemObjectMatchSet = d.UID_IntersectionEqualitySet8 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 9