List attribute primary key , index key , foreign key

All about the Doxygen documentation for Zeoslib.
Links to the downloads and online version.

Moderators: gto, bravecobra

lavoro92
Fresh Boarder
Fresh Boarder
Posts: 7
Joined: 23.03.2011, 16:32

List attribute primary key , index key , foreign key

Postby lavoro92 » 10.04.2011, 18:57

How to get List of primary key , index key and foreign key and relative property( for example the external table reference for the foiregn key) throught Zeoslib components?

tintinux
Junior Boarder
Junior Boarder
Posts: 41
Joined: 19.05.2010, 10:39

Postby tintinux » 11.04.2011, 09:48

Hi

I think it is possible only by querying the information schema, and depends on the database and it's release.

I made something working for MySql 5, if you are interested.

Regards
Tintinux

lavoro92
Fresh Boarder
Fresh Boarder
Posts: 7
Joined: 23.03.2011, 16:32

Postby lavoro92 » 11.04.2011, 12:25

Are there other methods that do this ?
I prefer use a class method because i want the list of primary key , foreign key , index key for mssql,mysql,postgresql,interbase,firebird,sqllite and oracle dbms .

tintinux
Junior Boarder
Junior Boarder
Posts: 41
Joined: 19.05.2010, 10:39

Postby tintinux » 11.04.2011, 12:42

None, that I know...
You will have an hard work with all these different databases.
It would be really useful to share it.
Buon lavoro !

User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Postby mdaems » 19.05.2011, 20:41

Have a look at the TZMetadata component. And maybe the zdbc metadata interfaces may be usefull for you too.

I don't think everything you asked for is available through the TZMetadata component, but maybe on the lower level more is available.

Mark
Image


Return to “Documentations”

Who is online

Users browsing this forum: No registered users and 1 guest