Page 1 of 1
List all indexes on a table
Posted: 21.02.2013, 22:30
by 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.
Posted: 22.02.2013, 12:07
by 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?
Posted: 23.02.2013, 20:47
by aleroot
Never used the Dbc-tier, can you post an example ?
Thanks.
Posted: 24.02.2013, 10:20
by EgonHugeist
I'll prepare something...