Adam,

Thank you very very much. The SQL was exatcly what I was loking for.

Andrew

> 3. Interrogate System tables
>
> select
> case when exists
> (
> select *
> from RDB$GENERATORS
> WHERE Upper(RDB$GENERATOR_NAME) = Upper('whatever')
> )
> then 'T' else 'F' end as GeneratorExists
> from RDB$DATABASE;