Skip to Main Content

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!

how to check where the table field was used as foreign key in database

Tony007May 9 2013 — edited May 9 2013
hi i have a field in my table office i got field office_code ,this field is been used in diffirent tables as foreign key is there a sql i can wirte to see all tables who have used this field as foreign key

Edited by: adf009 on 2013/05/09 10:37 AM

Edited by: adf009 on 2013/05/09 10:38 AM
This post has been answered by santhosh T on May 9 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 6 2013
Added on May 9 2013
12 comments
1,543 views