Page 1 of 1

TABLES AND KEYS

Posted: Wed 22 Mar 2017 11:28
by vicnetepc
Please.
Who can give me an example of a delphi code that shows the tables of a database (mysql, sqlserver, oracle, postgres) and information of each relationship: pk table name, pk name, fk table name, fk name.
* for delphi berlin 10.

Re: TABLES AND KEYS

Posted: Fri 24 Mar 2017 10:18
by azyk
In UniDAC to obtain the specified metadata use the TUniMetaData component: https://www.devart.com/unidac/docs/?dev ... tadata.htm

The sample of using TUniMetaData you can find in SDAC documentation:
https://www.devart.com/sdac/docs/?devar ... tadata.htm