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

Posted by Titi Ala'ilima on
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.