پیدا کردن ارتباط جداول

[java2]

کد: انتخاب همه

select table_name
from all_constraints
where constraint_type='R'
and r_constraint_name in 
  (select constraint_name
  from all_constraints
  where constraint_type in ('P','U')
  and table_name='PERSON'); 

منبع StackOverFlow