Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: DB Schema visualization
"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