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.
|
|
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. | |
PRECOMPILE_OPTIONS | VARCHAR (1024) | 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) | 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. | |
DEFINER1 | VARCHAR (128) | Authorization ID of the owner of the trigger. | |
REMARKS | VARCHAR (254) | Y | User-provided comments, or the null value. |
Note:
|