USER_TRIGGERS v16

The USER_TRIGGERS view displays information about all triggers on tables owned by the current user.

NameTypeDescription
schema_nameTEXTName of the schema in which the trigger resides.
trigger_nameTEXTName of the trigger.
trigger_typeTEXTThe type of the trigger. Possible values are: BEFORE ROW, BEFORE STATEMENT, AFTER ROW, AFTER STATEMENT.
triggering_eventTEXTThe event that fires the trigger.
table_ownerTEXTThe user name of the owner of the table on which the trigger is defined.
base_object_typeTEXTIncluded only for compatibility. Value is always TABLE.
table_nameTEXTName of the table on which the trigger is defined.
referencing_namesTEXTIncluded only for compatibility. Value is always REFERENCING NEW AS NEW OLD AS OLD.
statusTEXTStatus indicates if the trigger is enabled (VALID) or disabled (NOTVALID).
descriptionTEXTIncluded only for compatibility.
trigger_bodyTEXTThe body of the trigger.
action_statementTEXTThe SQL command that executes when the trigger fires.