--- In firebird-support@yahoogroups.com, "kfkong" <kfkong@y...> wrote:

> 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?

ALTER TRIGGER xxx INACTIVE

But it would be more practical to build a new blank database, and pump
the data from the old one. That way you can monitor what is going on.

--
Lester Caine
----------------------------
L.S.Caine Elcetonic Services