STORED_PROC_TRIGGERS

Contains information about Triggers.

Column Name	Data Type	Description
TRIGGER_NAME	VARCHAR	The name of the trigger.
NAMESPACE_NAME	VARCHAR	For Eon Mode databases, the trigger's namespace.
SCHEMA_NAME	VARCHAR	The trigger's schema. If the schema belongs to a non-default namespace in an Eon Mode database, the schema name is front-qualified with the name of the schema's namespace. For example, `n1.s` refers to schema `s` in namespace `n1`.
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