ALTER TRIGGER
ALTER TRIGGER trigger‑element SET {ENABLED | DISABLED}
where:
trigger‑element::= [catalog‑name.[schema‑name.]]trigger‑name
Access requirements
SYS_ADMIN_ROLE role
Usage
Use the ALTER TRIGGER statement to enable and disable triggers. For more information about triggers, see
Triggers.
Parameters, clauses, keywords, and variables
▪ ENABLED: Trigger runs when an activating DML statement is executed.
▪ DISABLED: Trigger is ignored when an activating DML statement is executed.
Examples
ALTER TRIGGER trig_on_employee SET ENABLED;
Go up to