List all indexes on a table

[aleroot]

Hi,
is it possible to list all indexes on a table in a standard and database independent way ?

How can it be done ?

Thanks.

[EgonHugeist]

aleroot,

The TZMetaData-Component can help you here!

OR:

Code: Select all

TZConnection.DbcConnection.GetMetaData.etIndexInfo(const Catalog: string; const Schema: string; const Table: string; Unique: Boolean; Approximate: Boolean): IZResultSet;

If you ever worked with the Dbc-tier. Did you?

[aleroot]

Never used the Dbc-tier, can you post an example ?


Thanks.

[EgonHugeist]

I'll prepare something...