You can disable and enable triggers in some Procedural Language (PL) scenarios.
You may need to temporarily disable a trigger in the following scenarios:
The trigger cannot be compiled because a database object that the trigger depends on does not exist.
The logic of the trigger does not meet your business needs.
You want to load, modify, or delete a large amount of data without executing any trigger.
You can enable a disabled trigger as needed.
You can use the ALTER TRIGGER statement in conjunction with a DISABLE or an ENABLE clause to enable or disable a trigger.
Disable a trigger by using the following syntax:
ALTER TRIGGER trigger_name DISABLE;
Enable a trigger by using the following syntax:
ALTER TRIGGER trigger_name ENABLE;
For more information about triggers, see Query trigger information.
