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:
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:
|
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.