List all indexes on a table

In this forum we will discuss things relating the ZEOSLib 6.6.x stable versions

Moderators: gto, EgonHugeist

aleroot
Fresh Boarder
Fresh Boarder
Posts: 13
Joined: 21.02.2013, 22:27

List all indexes on a table

Postby aleroot » 21.02.2013, 22:30

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

How can it be done ?

Thanks.

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1739
Joined: 31.03.2011, 22:38

Postby EgonHugeist » 22.02.2013, 12:07

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?
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image

aleroot
Fresh Boarder
Fresh Boarder
Posts: 13
Joined: 21.02.2013, 22:27

Postby aleroot » 23.02.2013, 20:47

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


Thanks.

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1739
Joined: 31.03.2011, 22:38

Postby EgonHugeist » 24.02.2013, 10:20

I'll prepare something...
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image


Return to “6.6 - stable”

Who is online

Users browsing this forum: No registered users and 1 guest