How to find tables with foreign keys that reference a specific table

Question

Suppose my database contains the following tables :

table_A with primary key PKA
table_B with foreign key FKA

Suppose also that I have no clue of the content of the database, except that it contains a table named table_A.

Here is my question : given table_A's name, what (PL/)SQL request do I have to make to the database to know that there is a table B that has a foreign key to table A ?

I'm using Oracle 11g

Check this: http://stackoverflow.com/questions/201621/how-do-i-see-all-foreign-keys-to-a-table-or-column — Hardy, Jan 27 '14 at 14:44
Depends heavily on which sql rdbms you are using - please specify which sql you are using in your tags. — StuartLC, Jan 27 '14 at 14:45
You need to specify your DBMS. The system catalogs (although *somewhat* standardized) are extremely different between the different vendors — a_horse_with_no_name, Jan 27 '14 at 14:47
May [the post](http://stackoverflow.com/questions/5535990/oracle-get-foreign-keys/5536400#comment30931113_5536400) will help you — Mohsen Heydari, Jan 28 '14 at 15:35

score 0 · Answer 1 · answered Jan 27 '14 at 14:47

0

On Sql Server, you'd issue sp_help TableA

One of the result sets will let you know that TableA is referenced by TableB's foreign key.

answered Jan 27 '14 at 14:47

Amy B

105,294
20
131
182

score 0 · Accepted Answer · edited May 23 '17 at 12:03

0

Hardy solved it ! Many thanks.

The answer lies in another topic, sorry for missing it.

edited May 23 '17 at 12:03

Community

1
1

answered Jan 27 '14 at 15:06

Backslash36

580
1
11
26

How to find tables with foreign keys that reference a specific table

2 Answers2