hanszorn2000 wrote:

>
> And if this is the case, how do I find 'index 7'? Normally, indexes
> are referred to by names, constraints etc, is there a translation to
> these?
>

Look at the system table rdb$indicies. Specifically use this
query:

select rdb$index_name from rdb$indicies where
rdb$relation_name = <table name> and
rdb$index_id = <reported index number>


Regards,


Ann