Each row represents a trigger. For table hierarchies, each trigger is recorded only at the level of the hierarchy where the trigger was created.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
TRIGSCHEMA | VARCHAR (128) | Schema name of the trigger. | |
TRIGNAME | VARCHAR (128) | Unqualified name of the trigger. | |
OWNER | VARCHAR (128) | Authorization ID of the owner of the trigger. | |
OWNERTYPE | CHAR (1) |
|
|
TABSCHEMA | VARCHAR (128) | Schema name of the table or view to which this trigger applies. | |
TABNAME | VARCHAR (128) | Unqualified name of the table or view to which this trigger applies. | |
TRIGTIME | CHAR (1) | Time at which triggered actions are applied to the base table,
relative to the event that fired the trigger.
|
|
TRIGEVENT | CHAR (1) | Event that fires the trigger.
|
|
EVENTUPDATE | CHAR (1) | Indicates whether an update event fires the trigger.
|
|
EVENTDELETE | CHAR (1) | Indicates whether a delete event fires the trigger.
|
|
EVENTINSERT | CHAR (1) | Indicates whether an insert event fires the trigger.
|
|
GRANULARITY | CHAR (1) | Trigger is executed once per:
|
|
VALID | CHAR (1) |
|
|
CREATE_TIME | TIMESTAMP | Time at which the trigger was defined. Used in resolving functions and types. | |
QUALIFIER | VARCHAR (128) | Value of the default schema at the time of object definition. Used to complete any unqualified references. | |
FUNC_PATH | CLOB (2K) | SQL path in effect when the trigger was defined. | |
TEXT | CLOB (2M) | Full text of the CREATE TRIGGER statement, exactly as typed. | |
LAST_REGEN_TIME | TIMESTAMP | Time at which the packed descriptor for the trigger was last regenerated. | |
COLLATIONSCHEMA | VARCHAR (128) | Schema name of the collation for the trigger. | |
COLLATIONNAME | VARCHAR (128) | Unqualified name of the collation for the trigger. | |
COLLATIONSCHEMA_ORDERBY | VARCHAR (128) | Schema name of the collation for ORDER BY clauses in the trigger. | |
COLLATIONNAME_ORDERBY | VARCHAR (128) | Unqualified name of the collation for ORDER BY clauses in the trigger. | |
DEFINER1 | VARCHAR (128) | Authorization ID of the owner of the trigger. | |
SECURE | CHAR (1) | Indicates whether the trigger is secure for row and column
access control
|
|
ALTER_TIME | TIMESTAMP | Time at which the trigger was last altered. | |
DEBUG_MODE | VARCHAR (8) | Indicates whether the trigger can be debugged
using the DB2® debugger.
|
|
ENABLED | CHAR (1) | Reserved for future use. | |
LIB_ID | INTEGER | Y | Internal identifier for compiled SQL triggers. Otherwise, the null value. |
PRECOMPILE_OPTIONS | VARCHAR(1024) | Y | The precompile and bind options that were in effect when the compiled trigger was created. The null value if the trigger is not compiled. |
COMPILE_OPTIONS | VARCHAR(1024) | Y | The value of the SQL_CCFLAGS special register that was in effect when the compiled trigger was created and inquiry directives were present. An empty string if no inquiry directives were present in the compiled trigger. The null value if the trigger is not compiled. |
ENVSTRINGUNITS | VARCHAR (11) | Default string units when the object was created. | |
REMARKS | VARCHAR (254) | Y | User-provided comments, or the null value. |
Note:
|