Hi,

We have a mysql database for which I would like to create a
documentation. For this I am searching for some tool that can read the
database structure (either from the mysql instance or from SQL code)
and create a visual picture of table relationships. Does anyone know if
such tool is available?

regards Jesper

jesper.lundstrom [at] gmail.com wrote:
> Hi,
>
> We have a mysql database for which I would like to create a
> documentation. For this I am searching for some tool that can read the
> database structure (either from the mysql instance or from SQL code)
> and create a visual picture of table relationships. Does anyone know if
> such tool is available?

The diagram that does this is called an entity-relationship diagram, or
an ER diagram.

DBDesigner 4 can do this.
hhttp://fabforce.net/dbdesigner4/

Also MySQL has MySQL Workbench, a new similar product in beta.
http://dev.mysql.com/downloads/workbench/1.0.html

Regards,
Bill K.

Thanks a lot I'll give the dbdesigner a shot...

/J


Bill Karwin wrote:
> jesper.lundstrom [at] gmail.com wrote:
> > Hi,
> >
> > We have a mysql database for which I would like to create a
> > documentation. For this I am searching for some tool that can read the
> > database structure (either from the mysql instance or from SQL code)
> > and create a visual picture of table relationships. Does anyone know if
> > such tool is available?
>
> The diagram that does this is called an entity-relationship diagram, or
> an ER diagram.
>
> DBDesigner 4 can do this.
> hhttp://fabforce.net/dbdesigner4/
>
> Also MySQL has MySQL Workbench, a new similar product in beta.
> http://dev.mysql.com/downloads/workbench/1.0.html
>
> Regards,
> Bill K.