or even :)

select 'DROP TRIGGER ' || rdb$trigger_name || ';'
from rdb$triggers
where rdb$trigger_name like 'TNI_%'

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

_________________________________________________________________
Tired of 56k? Get a FREE BT Broadband connection
http://www.msn.co.uk/specials/btbroadband