PDA

View Full Version : MySql schema



Nano
May 18th, 2007, 01:17 PM
Hi there, guys.
One question, does anyone of you know some software that will help me to print out the table relations and database schema for mysql?

Something that will print out the table definitions and its arrows connecting the keys with other tables' keys.

Any ideas?

Thanks in advance

FuriousLettuce
May 18th, 2007, 01:34 PM
Correct me if I'm wrong, but last time I used MySQL (about a year or two ago, properly) it didn't actually use relational databases, the relations were handled in the SQL with e.g., "LEFT JOIN" statements. If you want to easily administer the database, and view the tables etc., it'd be worth you checking out PHPMyAdmin, which is a PHP-based administering front-end to MySQL.

Nano
May 18th, 2007, 05:39 PM
Well, independently from relational databases, I need a software to see the scheme drawing, I might add the relations by hand.
Any clue?

ricrac
May 18th, 2007, 08:04 PM
mysql workbench
mysqladministrator
rekall
tora