How can I check if a generator already exixts?
Thanks.

Thanks.

> {quote:title=quinn wildman wrote:}{quote}
> Simplest is just try to create it. If it exists, you will get an error.
> 
> However, you could query rdb$generators. Example:
> 
> select count(*) from rdb$generators where rdb$generator_name='MYGENERATOR'
> 
> If this returns 0, no generator. If it returns 1, there is a generator. 
> If it returns something >1, you have an invalid query.
> 
> Roberto Colpani wrote:
> > How can I check if a generator already exixts?
> > Thanks.
> >

Simplest is just try to create it. If it exists, you will get an error.

However, you could query rdb$generators. Example:

select count(*) from rdb$generators where rdb$generator_name='MYGENERATOR'

If this returns 0, no generator. If it returns 1, there is a generator. 
If it returns something >1, you have an invalid query.

Roberto Colpani wrote:
> How can I check if a generator already exixts?
> Thanks.
>