Subject Re: [IBO] IBOStatisticalService: How to get all the detailed Index information?
Author Helen Borrie
At 11:53 PM 22/11/2004 +1030, you wrote:

>There are many UNIQUE indexes, i.e. not input as INDEXes but as UNIQUE
>statements. These do not appear. Is this a bug or as designed?

They do here. Perhaps the index names are hard to recognise in your
database. In an older database, the indexes created for UNIQUE constraints
typically have names like "RDB$11" (which is a UNIQUE constraint on
Project.Proj_Name in the Employee database, if you want to give that one a
try), regardless of whether you named the constraint or not.

In a Firebird 1.5 database, the index on a UNIQUE constraint will have the
same name as the constraint, if you make it a named constraint; or you can
provide a specific name with a USING clause.