catalog.triggers table
The catalog.triggers table stores information about triggers, including the type of trigger, the trigger priority, and what trigger group it is in.
The following table describes the columns in the catalog.triggers table.
| Column name | Data type | Description |
|---|---|---|
| TriggerName | varchar(40) | Name of the trigger. |
| GroupName | varchar(40) | Trigger group name. |
| TriggerKind | integer | Type of trigger: 0: Database 1: Signal 2: Temporal |
| DebugEnabled | Boolean | TRUE if debugging is enabled for the trigger. |
| IsEnabled | Boolean | TRUE if the trigger is enabled. |
| TriggerPriority | integer | Trigger priority: 1 is the highest, 20 is the lowest priority. |
| CommentBlock | varchar(1024) | Comment string specified in the CREATE TRIGGER command. |
| EvaluateBlock | varchar(2048) | Evaluation clause specified in the CREATE TRIGGER command. |
| BindName | varchar(40) | Bind name specified in the evaluation clause of the CREATE TRIGGER command. |
| ConditionBlock | varchar(1024) | When condition specified in the CREATE TRIGGER command. |
| DeclareBlock | varchar(1024) | Variable declaration specified in the CREATE TRIGGER command. |
| CodeBlock |
|
The body of the trigger. |
varchar(32768)