Disabling and Reenabling Triggers

You can disable and reenable multiple triggers using the alter table command.

Use the alter table command to disable or reenable multiple triggers individually:

To disable or reenable the trigger, use:
alter table table_name {disable | enable} trigger trigger_name
Parent topic: Multiple Triggers