ADM_TRIGGERS

ADM_TRIGGERS displays information about triggers in the database. By default, only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in the PG_CATALOG and SYS schemas.

**Table 1** ADM_TRIGGERS columns
Name	Type	Description
owner	character varying(128)	Trigger owner.
trigger_name	character varying(64)	Trigger name.
trigger_type	character varying	Time when a trigger is triggered. Value range: before statement, before each row, after statement, after each row, and instead of.
triggering_event	character varying	Event that triggers a trigger. Value range: update, insert, delete, and truncate.
table_owner	character varying(64)	Owner of the table that defines a trigger.
base_object_type	character varying(18)	Defines the basic object of a trigger. Its values can be table and view.
table_name	character varying(64)	Name of the table or view that defines a trigger.
column_name	character varying(4000)	Not supported. Its value is NULL.
referencing_name	character varying(422)	Not supported. Its value is referencing new as new old as old.
when_clause	character varying(4000)	Content of the WHEN clause. trigger_body can be executed only when the value is true.
status	character varying(64)	Trigger status. O: The trigger is enabled in origin or local mode. D: The trigger is disabled. R: The trigger is enabled in replica mode. A: The trigger is always enabled.
description	character varying(4000)	Trigger description, which is used to rebuild a trigger creation statement.
action_type	character varying(11)	Action type of a trigger, which only supports call.
trigger_body	text	Statement executed when a trigger is triggered.
crossedition	character varying(7)	Not supported. Its value is NULL.
before_statement	character varying(3)	Not supported. Its value is NULL.
before_row	character varying(3)	Not supported. Its value is NULL.
after_row	character varying(3)	Not supported. Its value is NULL.
after_statement	character varying(3)	Not supported. Its value is NULL.
instead_of_row	character varying(3)	Not supported. Its value is NULL.
fire_once	character varying(3)	Not supported. Its value is NULL.
apply_server_only	character varying(3)	Not supported. Its value is NULL.