Re: DB Schema visualization

Jens Lenge wrote:
> Who can recommend a software tool that create a graphical visualizion
> of an existing Oracle database schema? (Like displaying all tables as
> boxes with their column names and data types inside, and references
> such as foreign keys as lines between the tables.)
>
> I would prefer a tool that is free and possibly not Oracle-specific if
> there is one.
> Any hints are welcome.
>
> Jens
>

Visio has a tool that will connect to your database via ODBC and generate an ERD diagram. It uses the defined FK constraints to know which tables relate to which tables.

Visio is now owned by M$, and it is not free. However, it is a good tool.

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