marcosvidolin
9/18/2013 - 7:28 PM

Oracle - See all table relationships

Oracle - See all table relationships

select table_name from user_constraints
where r_constraint_name in
  (select constraint_name 
     from user_constraints
     where constraint_type in ('P','U')
     and table_name = upper('&tableOfInterest')
  )