Disabling and Enabling a Trigger

The ALTER TRIGGER statement can stop a trigger by disabling it.

ALTER TRIGGER your_trigger_name DISABLE;

ALTER TRIGGER your_trigger_name ENABLE;

1. Triggers
2. Getting Information on Triggers
3. Disabling and Enabling a Trigger
4. Dropping a Trigger