TRIGGER_COLUMN_USAGE
The TRIGGER_COLUMN_USAGE view lists the table columns on which triggers, that owned by the current ident, depend because they are referenced in the search condition of the trigger or in one of the statements in the body of the trigger.
Column name
|
Data type
|
Description
|
| TRIGGER_CATALOG |
VARCHAR(128) |
The name of the catalog containing the trigger. |
| TRIGGER_SCHEMA |
VARCHAR(128) |
The name of the schema containing the trigger. |
| TRIGGER_NAME |
VARCHAR(128) |
The name of the trigger. |
| TABLE_CATALOG |
VARCHAR(128) |
The name of the catalog containing the referenced table or view. |
| TABLE_SCHEMA |
VARCHAR(128) |
The name of the schema containing the referenced table or view. |
| TABLE_NAME |
VARCHAR(128) |
The name of the referenced table or view. |
| COLUMN_NAME |
VARCHAR(128) |
The name of the referenced column. |
