Generate graphical schema representation from CREATE TABLE SQL

Question

Hi all,

I have a .sql file containing many CREATE TABLE statements. There's no referential specification (MyISAM stuff) but I would enjoy to create different table boxes, and then compose the table relationships by hand. I am using a mac. Is there a free program to do this ?

Answer 1

Yes, the MySQL Workbench can reverse-engineer a diagram from an SQL script that contains a set of CREATE TABLE statements.

Use the menu: File > Import > Reverse Engineer MySQL Create Script...

Answer 2

Go to SchemaBank, open a free account, import your sql file and start editing. Nothing to install at all.