Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Finding Foreign Key Referenced Table and Column

682388Mar 4 2009 — edited Aug 23 2013
Can someone please refresh my memory?

How can I determine what table and column a foreign key references?

For example, with select * from ALL_constraints WHERE TABLE_NAME = 'MY_TABLE'; I can see constraints CONSTRAINTA_FK and CONSTRAINTB_FK that I'm guessing reference another table and column because CONSTRAINT_TYPE = 'R", but that's as far as I get.

I would like to get all the way to the referenced table and column I just don't remember how.

Thanks,

Lou
This post has been answered by Walter Fernández on Mar 4 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 20 2013
Added on Mar 4 2009
8 comments
101,884 views