Unknown primary keys and foreign keys ina database

[bburan]

I would like to connect to a database and determine, on the fly, what columns are the foreign and primary keys for each table.  Is there any way to do this using the LabView Database connectivity toolkit or a SQL query?

Thank you!
Brad

[mikeporter]

In principle, yes. One of the requirements of a relational database is that all its own internal structure must also be stored in relational tables. Now having said that, the way different database management systems store that information is highly application-specific. Check-out the documentation of the database you are using on the specifics of how to find the information using SQL queries.

Mike...

[bburan]

Thank you for your help.  Now that I know what to look for, I should be able to track down the information I need (it's for MS Access).

Brad

[mikeporter]

Ok Access;

It's been a while, but as I recall there are "system tables" that define your database's structure. The one you're looking for I think is "MSysRelationships"

Mike...

[bburan]

Found it, thanks!  For future reference (for anyone who might search for this topic)

Go to: Tools -> Options -> View and check "system" and "hidden" objects to explore the structure of these tables.  It's not recommended to edit them directly for obvious reasons, but will at least give an idea of how to query them.

Brad