Back to OIM Explorer

dbo.DPR_TDDPRSchemaProperty

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on DPRSchemaProperty. Trigger parent table: DPRSchemaProperty

Source: sandbox-db sys.sql_modules

Source size: 542 characters

Interpretation

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

Relations

  • Trigger parent table: DPRSchemaProperty

Typed Edges

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

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL34 lines
1CREATE trigger DPR_TDDPRSchemaProperty2  ON DPRSchemaProperty FOR3DELETE NOT FOR replication4AS5BEGIN6  BEGIN TRY7    IF EXISTS(8      SELECT TOP 1 19      FROM deleted d10      WHERE11        d.UID_DPRSchemaPropertyReference > ' ')12    BEGIN13      GOTO start14    END15    ELSE16    BEGIN17      GOTO endLabel18    END19    start:20    DELETE DPRSchemaPropertyReference21    FROM DPRSchemaPropertyReference x22    JOIN deleted d23      ON x.UID_DPRSchemaPropertyReference = d.UID_DPRSchemaPropertyReference24  END TRY25  BEGIN CATCH26    EXEC QBM_PSessionErrorAdd DEFAULT27    RAISERROR('',28    18,29    1)30      WITH NOWAIT31  END CATCH32  endLabel:33  RETURN34END
Open raw exported source
SQL ยท Raw5 lines
1 create   trigger DPR_TDDPRSchemaProperty on DPRSchemaProperty  for delete not for replication as begin  BEGIN TRY if exists (select top 1 1 from2 deleted d where d.UID_DPRSchemaPropertyReference > ' ' ) begin goto start end else begin goto endLabel end start: delete DPRSchemaPropertyReference from3 DPRSchemaPropertyReference x join deleted d  on x.UID_DPRSchemaPropertyReference = d.UID_DPRSchemaPropertyReference END TRY BEGIN CATCH exec QBM_PSessionErrorAdd4 default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: return end 5