Adrian Wreyford wrote:

> I need some advice on how to test for the presence of an index, before
> running a script to update a database to a newer structure.
>

Have a look at the system tables RDB$INDICES and RDB$INDEX_SEGMENTS.
They should give you the information you need.


Regards,


Ann