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');
See Also¶
- Source code
- ENABLE_TRIGGERS procedure
- RECREATE_TRIGGER procedure
- DISABLE_TRIGGER procedure
- SYSCAT.TRIGGERS (built-in catalogue table)