SYSTRIGUPD
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. |
| SYSTEM_TRIGGER_SCHEMA | SYS_TDNAME | CHAR(10) | System schema name. |
| SYSTEM_EVENT_OBJECT_SCHEMA | SYS_DNAME | CHAR(10) | System schema name of the schema containing the subject table or view of the trigger. |
| SYSTEM_EVENT_OBJECT_TABLE | SYS_TNAME | CHAR(10) | System table name of the table or view that contains the subject table or view of the trigger. |