Disabling Triggers
You can disable a trigger via the ALTER TABLE…DISABLE TRIGGER command. Disabled triggers can be reenabled using ALTER TABLE…ENABLE TRIGGER. Here are a few examples (Listing 8-15):
Listing 8-15 Triggers can be disabled/enabled at will.
ALTER TABLE sales
DISABLE TRIGGER SalesQty_INSERT_UPDATE
ALTER TABLE sales
ENABLE TRIGGER SalesQty_INSERT_UPDATE
ALTER TABLE sales
DISABLE TRIGGER ALL
ALTER TABLE sales
ENABLE TRIGGER ALL