Networking HowTos
Networking HowTos

Enable and Disable Triggers in Firebird

November 30, 2012 Database, Firebird

The Firebird database engine supports the use of Triggers on its tables. Triggers are basically a set of SQL scripts that can be executed when data in a table is either inserted, updated, or deleted.
Sometimes you may want to temporarily disable a trigger without completely removing it. The steps to do this, and enable the trigger again, are outlined below.
Disable Trigger:

ALTER TRIGGER <trigger name> INACTIVE;

Enable Trigger:

ALTER TRIGGER <trigger name> ACTIVE;

Replace <trigger name> with the name of the trigger you wish to disable or enable.

You Might Also Like