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):
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 |