Switch to: V9V8V7V6V5

SHOW TRIGGERS

[NEW in 3.0]

SHOW TRIGGERS statement is used to list the triggers of the database. The result of this statement is a Cursor (VCursor) as with the SELECT statement.

Syntax

SHOW TRIGGERS [{FROM|OF} table_name] [{FROM|OF} db_name] 

Result Columns

  • fld_name

The name of the trigger.

  • fld_text

The text of trigger.

  • fld_enabled

The trigger status. One of 'ENABLED' or 'DISABLED'.

  • fld_foreachrow

Specifies if the trigger is fired for each row.

  • fld_time

One of the values 'BEFORE', 'AFTER', 'INSTEAD OF'.

  • fld_events

The event that causes trigger activation: one of 'INSERT', 'DELETE', 'UPDATE', 'UPDATE OF fields'.

  • fld_object_type

ObjectType contains 'TABLE' in case trigger is registered to some table and 'VIEW' otherwise.

  • fld_object_name

Specifies the name of owned object.

  • fld_custom_property_count

Specifies the count of trigger's custom properties.

  • fld_id

Specifies the id of trigger.

Examples

SHOW TRIGGERS;
SHOW TRIGGERS FROM dbAccounting;
SHOW TRIGGERS FROM tblAccount FROM dbAccounting;