Disabling Triggers

for RuBoard

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 

for RuBoard