SYSTRIGDEP Catalog Table for SQL Trigger

SYSTRIGDEP Catalog Table for SQL Trigger
SYSTRIGDEP Catalog Table for SQL Trigger, SYSTRIGDEP, SQL Trigger, db2 catalog, ibm catalog, ibmi, as400
SYSTRIGDEP Catalog Table for SQL Trigger

This article contains the SYSTRIGDEP catalog table used for SQL triggers.

SYSTRIGDEP

This view contains the specific information about the trigger in the SQL schema objects referenced in the WHEN clause or the triggered SQL statements of a trigger.

Structure of SYSTRIGDEP

Column Name Description
TRIGGER_SCHEMA Name of the schema containing trigger
TRIGGER_NAME Name of the trigger
OBJECT_SCHEMA Schema containing object referenced in the trigger
OBJECT_NAME Name of the object referred
OBJECT_TYPE The object type of the object referenced in the trigger
PARM_SIGNATURE Identifies the routine signature
SYSTEM_TRIGGER_SCHEMA System schema name
SYSTEM_OBJECT_SCHEMA System schema name of the object referenced in the trigger
SYSTEM_OBJECT_NAME System object name referenced in the trigger

Example

Select * from QSYS2.SYSTRIGDEP

Result


Related Post

Post a Comment

© AS400 and SQL Tricks. All rights reserved. Developed by Jago Desain