DISABLE_TRIGGERS procedure

Disables all triggers associated with the specified table by saving their definitions to a table and dropping them.

Prototypes

DISABLE_TRIGGERS(ASCHEMA VARCHAR(128), ATABLE VARCHAR(128))
DISABLE_TRIGGERS(ATABLE VARCHAR(128))

Description

Disables all the operative triggers associated with a particular table. If a trigger exists, but is marked inoperative, it is not touched by this procedure. You can recreate such triggers with RECREATE_TRIGGER procedure before calling DISABLE_TRIGGERS.

Parameters

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

Examples

Disable all triggers on the FINANCE.LEDGER table:

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

Disable the triggers for the EMPLOYEE table in the current schema:

CALL DISABLE_TRIGGERS('EMPLOYEE');