don't know of one .... but you can do something like:

select 'alter trigger '||triggername||' inactive;'
from rdb$systemtables
select "alter trigger "||a.rdb$trigger_name||' inactive;'
from rdb$triggers a, rdb$relations b
where a.rdb$relation_name = b.rdb$relation_name
and b.rdb$system_flag = 0
and a.rdb$trigger_name not like "CHECK%"
;

and dump it into an output file - then run the output file.

bill



Raymond Kennington wrote:

>Is there a way to turn on/off all triggers with a single statement?
>
>