Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> determining the relationships between schema objects

determining the relationships between schema objects

From: Jeff Calico <jeffCalico_at_hotmail.com>
Date: 5 Sep 2006 12:53:38 -0700
Message-ID: <1157486018.031381.275550@i3g2000cwc.googlegroups.com>


I have inherited a project which seems to have no documentation. There are some 50 - 60 tables as well as sequences, indexes, constraints... I can find no sql script to look at that creates all these objects.

What is a good way to determine the relationships between the various tables?
"Good" meaning some more clever way than me manually looked at User_Catalog,
User_Tables, User_Tab_Columns, etc and drawing a diagram by pencil and paper.

Or if I had to do that, a clever SQL query is probably out there that would help organize everything...

thanks,
Jeff Received on Tue Sep 05 2006 - 14:53:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US