> or even :)
>
> select 'DROP TRIGGER ' || rdb$trigger_name || ';'
> from rdb$triggers
> where rdb$trigger_name like 'TNI_%'

Darn... I'm really getting sloppy... Time for a holiday. :-/

Or I could say: I leave the exact syntax as an exercise
for the reader.

*g*

--
Martijn

>
> >From: "Martijn Tonies" <m.tonies@...>
>
> >How about creating a script in an easy way, but still using
> >DROP TRIGGER?
> >
> >select 'DROP TRIGGER ' || rdb$trigger_name ';'
> >from rdb$triggers
> >where rdb$trigger_name like 'TNI_%'
> >
> >Save the output as a single text column and you have a working
> >script.