How can I find the prime / foreign keys and which tables these relate to??
2007-06-24 23:58:42 · 2 answers · asked by Robert A 1 in Computers & Internet ➔ Programming & Design
The answer is that the database should have an index table.
You select the table name and it will return all the indexes that have been defined with the columns that apply
You have not specified the database system so I cannot help any more.
I have found this link for MS SQL Server. Click on the download on the right to view a plan of the system tables. Go for the all database plan rather than the master database. You should have a similar set of tables for most database systems. It is just a question of finding out what they are.
2007-06-25 00:09:03 · answer #1 · answered by AnalProgrammer 7 · 0⤊ 0⤋
without knowing the database vendor/version that's impossible to answer. you need to update your question first.
2007-06-25 00:05:50 · answer #2 · answered by Nick W 2 · 1⤊ 0⤋