TABLES AND KEYS

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
vicnetepc
Posts: 2
Joined: Wed 09 Nov 2016 11:44

TABLES AND KEYS

Post by vicnetepc » Wed 22 Mar 2017 11:28

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.

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: TABLES AND KEYS

Post by azyk » Fri 24 Mar 2017 10:18

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

Post Reply