Forum OpenACS Q&A: Response to How do you find foreign keys in Oracle?

Collapse
4: Response to How do you find foreign keys in Oracle? (response to 1)
Posted by Titi Ala'ilima on 05/15/02 08:41 PM
I think this will do the trick: 
select table_name
from user_constraints
where r_constraint_name = 'SYS_C005133';

You can also use the schema-browser package, which, when working properly, makes navigating the data model a breeze.