Forum OpenACS Q&A: Response to How do you find foreign keys in Oracle?
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.