I'm not sure if I understand correctly, but the all_constraints table can be used to get the table relations.
This is an example query:
<pre>select ac.constraint_name,ac.table_name child_table,ac2.table_name parent_table
from all_constraints ac,all_constraints ac2
where ac.r_constraint_name = ac2.constraint_name;</pre>
Last Wiki Answer Submitted: September 16, 2008 9:57 pm by carlosdl63,535 pts.