ENABLE_TRIGGERS procedure

Enables all triggers associated with a specified table.

Prototypes

ENABLE_TRIGGERS(ASCHEMA VARCHAR(128), ATABLE VARCHAR(128))
ENABLE_TRIGGERS(ATABLE VARCHAR(128))

Description

Enables all the disabled triggers associated with a particular table. Note that this does not affect inactive triggers which are still attached to the table, just those triggers that have been disabled with DISABLE_TRIGGER procedure or DISABLE_TRIGGERS procedure. To reactivate inactive triggers, see RECREATE_TRIGGER procedure and RECREATE_TRIGGERS procedure.

Parameters

ASCHEMA
If provided, the schema containing the table for which to enable triggers. If omitted, defaults to the value of the CURRENT SCHEMA special register.
ATABLE
The name of the table to enable all disabled triggers for.

Examples

Enable all disabled triggers on the FINANCE.LEDGER table:

CALL ENABLE_TRIGGERS('FINANCE', 'LEDGER');

Enable the disabled triggers for the EMPLOYEE table in the current schema:

CALL ENABLE_TRIGGERS('EMPLOYEE');