Help Center/ GaussDB/ Developer Guide(Distributed_2.x)/ System Catalogs and System Views/ System Views/ ADM_TRIGGERS
Updated on 2023-10-23 GMT+08:00
View PDF
Share

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

trigger_name

character varying(64)

Trigger name

table_owner

character varying(64)

Role name

table_name

character varying(64)

Relational table name

status

character varying(64)
  • O: The trigger is initiated in origin or local mode.
  • D: The trigger is disabled.
  • R: The trigger is initiated in replica mode.
  • A: The trigger is always initiated.
Parent topic: System Views