DB2 Universal Database for iSeries SQL Reference

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 129. 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.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]