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.

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

• 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.

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