I use MySql and need to have a diagram showing how the tables and
their fields and how the tables are related.

Till now I have generated the tables in MS Access just to get a
diagram, but surely there must exist better ways.

Do you know of a free database chart program?

Regards,

Jan Nordgreen

damezumari <jannordgreen (AT) gmail (DOT) com> wrote:

I do not know if it will do the trick for databases, but try
UMLet (umlet.com). I used it for class diagrams in a programming
course. It is simple, but it works fairly well.

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.

"damezumari" <jannordgreen (AT) gmail (DOT) com> wrote

Here's what I did one time:

Generate the tables in Oracle.
Generate table links to the Oracle tables in MS Access.
Define the relationships (foreign key/primary key) in MS Access, for the
table links.

Generate the relationship diagram in MS Access.

It's actually fewer steps than generating the tables in MS Access first.
Plus, it's easy to keep your diagram in synch with your actual tables as
the schema evolves.

On May 11, 10:38 pm, damezumari <jannordgr... (AT) gmail (DOT) com> wrote:

Jan,

Try the new MySQL Tools:
http://www.mysql.com/products/tools/

Specifically, the Administrator will do an automatic chart of your DB:
http://www.mysql.com/products/tools/administrator/

Hope this helps,
LB

--
Online video? Conan O' Brien gets it right!
http://blogs.pcworld.com/tipsandtwea...es/004369.html

Thanks to everyone for their tips!

LB, I downloaded MySql Administrator. I go to Catalogs and see tabs
for Scema Tables, Schema Indices, View, and Stored Procedures. Could
you please tell me how I create an image showing how the tables are
related as in MS Access?

At the moment I use the free trial version of RFFlow. It can be
downloaded here: http://www.rff.com/download.htm

Regards,

Jan Nordgreen