The SYSTRIGUPD view contains one row for each column identified in the UPDATE column list, if any. The following table describes the columns in the SYSTRIGUPD 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. |
EVENT_OBJECT_SCHEMA | TABSCHEMA | VARCHAR(128) | Name of the schema containing the subject table of the trigger. |
EVENT_OBJECT_TABLE | TABNAME | VARCHAR(128) | Name of the subject table of the trigger. |
TRIGGERED_UPDATE_COLUMNS | TABCOLUMN | VARCHAR(128) | Name of a column specified in the UPDATE column list of the trigger. |
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.