Re: Making an ERD from an existing db

From: Frank Downs <frank.downs_at_webmail.co.za>
Date: Thu, 29 Oct 1998 20:20:08 GMT
Message-ID: <3638cddd.20491742@dbn-news.iafrica.com>

There are a few ways to obtain this information. Some methods require far more effort that others, but as usual convenience costs money.

The hardest way to construct an ERD is to log in as the owner of the tables and select the following columns from the USER_CONSTRAINTS view ; - constraint_type - table_name - r_constraint_name (obviously you can do some filtering on the result set so that you can focus on the tables/constraints you are interested in).
Next on the list is Oracle Enterprise Manager's SCHEMA MANAGER. If you right click on a table and select SHOW DEPENDENCIES you will be able to tell which tables have FKs on the current table and which tables the current table has FKs on.
The easiest, but most exensive, way is to reverse engineer the tables using a tool like Designer 2000.

Frank

>I have an existing Oracle rdbms for which I would like to draw up an ERD.
>How can I get PK and FK information from the DB in the process of
>determining the realtionships btw the tables as I do a desc on each
>table??
>
>Thanks!!.Dan
Received on Thu Oct 29 1998 - 14:20:08 CST