system.triggers

Advantage SQL Engine

Contains one row for each trigger in the database.

Field Name

Field Type

Field Size

Description

Name

Character

200

Trigger name.

Trig_TableName

Character

200

The table the trigger is assigned to.

Trig_Event_Type

Integer

4

The type of event that causes a trigger to fire.

Trig_Trigger_Type

Integer

4

The kind of event the trigger should fire on.

Trig_Container_Type

Integer

4

The type of container holding the trigger.

Trig_Container

Memo

variable

The name of the trigger container. This value varies depending on the container type.

Trig_Function_Name

Character

260

The name of the function called when the trigger is executed.

Trig_Priority

Integer

4

Determines when the trigger is fired in relation to other triggers.

Trig_Options

Integer

4

Options for the trigger in numeric format.

Comment

Memo

variable

The description of the trigger.