SYSTRIGCOL

The SYSTRIGCOL view contains one row for each column either implicitly or explicitly referenced in the WHEN clause or the triggered SQL statements of a trigger. The following table describes the columns in the SYSTRIGCOL view:

Table 134. SYSTRIGCOL view
Column Name System Column Name Data Type Description
TRIGGER_SCHEMA TRIGSCHEMA VARCHAR(128) Name of the schema containing the trigger.
TRIGGER_NAME TRIGNAME VARCHAR(128) Name of the trigger.
TABLE_SCHEMA TABSCHEMA VARCHAR(128) Name of the schema containing the table or view that contains the column that is referenced in the trigger.
TABLE_NAME TABNAME VARCHAR(128) Name of the table or view that contains the column that is referenced in the trigger.
COLUMN_NAME TABCOLUMN VARCHAR(128) Name of the column that is referenced in the trigger.
OBJECT_TYPE BTYPE CHAR(24) Indicates the object type of the object that contains the column referenced in the trigger:
FUNCTION
The object is a function.
MATERIALIZED QUERY TABLE
The object is a materialized query table.
TABLE
The object is a table.
VIEW
The object is a view.