Skip to content

Instantly share code, notes, and snippets.

@marcosvidolin

marcosvidolin/table_relationships.sql

Created September 18, 2013 19:28
Show Gist options
  • Save marcosvidolin/6614268 to your computer and use it in GitHub Desktop.
Save marcosvidolin/6614268 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle - See all table relationships
Raw
table_relationships.sql
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')
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment