Disabling and Reenabling Triggers

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

Use the alter table command to disable or re-enable multiple triggers individually:

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