Clever Geek Handbook

Creating a Graphical Schema View from CREATE TABLE SQL

I have a .sql file that contains many CREATE TABLE statements. There is no referencing BOM (MyISAM stuff), but I would find it helpful to create different table fields and then compose the relationships in the table by hand. I am using mac. Is there a free program for this?

+2


source to share


2 answers


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

.



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

+4


source


Go to SchemaBank , open a free account, import your sql file and start editing. You don't need to install anything.



+2


source






More articles:


All Articles