You can disable all non-system triggers by executing the following
statement:

UPDATE RDB$TRIGGERS
SET RDB$TRIGGER_INACTIVE = 1
WHERE NOT (R.RDB$TRIGGER_NAME STARTING WITH 'RDB$')


Then after your updates,

UPDATE RDB$TRIGGERS
SET RDB$TRIGGER_INACTIVE = 0
WHERE NOT (R.RDB$TRIGGER_NAME STARTING WITH 'RDB$')

To reactivate them.

-----Original Message-----
From: kfkong [mailto:kfkong@...]
Sent: Sunday, April 18, 2004 5:57 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Firebird 1.5 Trigger

I am trying to upgrade my existing Firebird db. However due to some
tables modification and update statement may fire my triggers which
will end up disturbing or even corrupting my existing data on
another table. Is there a way that I can
switch all triggers off during my FB DB upgrade?