Navigation:  Advantage SQL > System Views > Views >

system.triggers

Advantage SQL Engine

Previous pageReturn to chapter overviewNext page

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. For database triggers, this is null.

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.