Contains one row for each trigger.
Table 69. SYSCAT.TRIGGERS Catalog View
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| TRIGSCHEMA | CHAR(8) |
| Qualified name of the trigger. |
| TRIGNAME | VARCHAR(18) |
| |
| DEFINER | CHAR(8) |
| Authorization ID under which the trigger was defined. |
| TABSCHEMA | CHAR(8) |
| Qualified name of the table to which this trigger applies. |
| TABNAME | VARCHAR(18) |
| |
| TRIGTIME | CHAR(1) |
| Time when triggered actions are applied to the base table, relative to
the event that fired the trigger:
B=Trigger applied before event A=Trigger applied after event |
| TRIGEVENT | CHAR(1) |
| Event that fires the trigger.
I=Insert D=Delete U=Update |
| GRANULARITY | CHAR(1) |
| Trigger is executed once per:
S=Statement R=Row |
| VALID | CHAR(1) |
|
Y=Trigger is valid
X=Trigger is inoperative;
must be re-created.
|
| TEXT | CLOB(32K) |
| The full text of the CREATE TRIGGER statement, exactly as typed. |
| CREATE_TIME | TIMESTAMP |
| Time at which the trigger was defined. Used in resolving functions and types. |
| FUNC_PATH | VARCHAR(254) |
| Function path at the time the trigger was defined. Used in resolving functions and types. |
| REMARKS | VARCHAR(254) | Yes | User-supplied comment, or null. |