Hi,

> > > Is there some problem in delete triggers directly in
> RDB$TRIGGERS
> > > table?
> >
> > Why?
> I have to delete several triggers (about 800-900), in several
> databases, all created with a database design tool.
>
> All these triggers have the same prefix in it's names, like TNI_*,
> TND_*, TNU_*, and the temptation to do that in a single operation
> instead of making a script (the trigger names inside each database
> are not the same) is VERY BIG!!!

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.


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com