The USER_TRIGGERS view provides the information about all triggers on tables owned by the current user.
Parameter | Type | Description |
---|---|---|
schema_name | TEXT | The name of the schema to which the trigger belongs. |
trigger_name | TEXT | The name of the trigger. |
trigger_type | TEXT |
The type of the trigger. Valid values:
|
triggering_event | TEXT | The event that fires the trigger. |
table_owner | TEXT | The username of the owner of the table on which the trigger is defined. |
base_object_type | TEXT | This parameter is supported for compatibility only. The value is TABLE. |
table_name | TEXT | The name of the table on which the trigger is defined. |
referencing_names | TEXT | This parameter is supported for compatibility only. The value is REFERENCING. NEW AS NEW OLD AS OLD. |
status | TEXT | Specifies whether the trigger is enabled (VALID) or disabled (NOTVALID). |
description | TEXT | This parameter is supported for compatibility only. |
trigger_body | TEXT | The body of the trigger. |
action_statement | TEXT | The SQL statement that is executed when the trigger fires. |