Or even update the rdb$triggers table directly .... (I thought after I
posted ... sorry)

bill

Bill Katelis wrote:

>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?
>>
>>
>>
>>
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>