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 -> Re: DB Schema visualization

Re: DB Schema visualization

From: Robbert van der Hoorn <removetheXinR.Xvanderhoorn_at_osait.nl>
Date: Thu, 13 Jul 2006 15:17:56 +0200
Message-ID: <44b6492d$0$31638$e4fe514c@news.xs4all.nl>

"Brian Peasland" <dba_at_nospam.peasland.net> wrote in message news:J2CEx6.KL7_at_igsrsparc2.er.usgs.gov...
> 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.

Pitty, Oracle Designer is very capable of doing what you ask here..

> > 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
Received on Thu Jul 13 2006 - 08:17:56 CDT

Original text of this message

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