STORED_PROC_TRIGGERS

Contains information about Triggers.

Column Name	Data Type	Description
TRIGGER_NAME	VARCHAR	The name of the trigger.
SCHEMA_NAME	VARCHAR	The trigger's schema.
OWNER	VARCHAR	The owner of the trigger.
PROCEDURE_NAME	VARCHAR	The name of the stored procedure.
PROCEDURE_ARGS	INTEGER	The number of formal parameters in the stored procedure.
ENABLED	BOOLEAN	Whether the trigger is enabled.

Examples

To view triggers:

=> SELECT * FROM stored_proc_triggers;
  trigger_name  | schema_name |  owner  | procedure_name | procedure_args | enabled
----------------+-------------+---------+----------------+----------------+---------
 raise_trigger  | public      | dbadmin | raiseXY        | 2              | t