Re: determining the relationships between schema objects

Jeff Calico wrote:
> 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
>

There are no free tools that I know of. If your company has Visio, then Visio can connect to the database and read your Data Dictionary for you and generate a ERD diagram. If you do not want to pay for Visio, you might want to look into a product called Happy Fish (http://www.polderij.nl/happyfish/). It's low cost and does a pretty good job.

To reverse engineer your CREATE statements, use the DBMS_METADATA pkg. The following can do the trick:

SELECT dbms_metadata.get_ddl(object_type,object_name) FROM user_objects;

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown