How to generate Entity-Relation diagram from SQL DDL?

Question

For example DbVisualizer can be used to connect to a DB and create nice diagram out of existing tables and their relations. But in this specific case I do not have a live database but I have bunch of create table and alter statements.

Is there any tool to generate similar diagrams out of SQL DDL?

score 8 · Answer 1 · answered May 07 '11 at 16:49

8

I found the MySQL tool MySQL Workbench to do a great job. There is a Mac OS X version. More information can be found at http://dev.mysql.com/doc/index-gui.html.

answered May 07 '11 at 16:49

ahalls

1,095
1
12
23

I used MySQL Workbench on Windows, it generates diagram. You can click on Arrange -> Autolayout. It arranges all the entities automatically. Very helpful. – Ameer Tamboli Apr 29 '14 at 14:00
1

If you already have an existing database, you can use `Database -> Reverse Engineer...` to create a graphical mode. – Jonas Gröger Jun 22 '15 at 14:55

score 4 · Answer 2 · answered Aug 18 '10 at 20:39

4

SQLFairy will generate graphics from plain SQL DDL files:

http://sqlfairy.sourceforge.net/

answered Aug 18 '10 at 20:39

Joshua Orvis

41
1

1

example of usage to achieve that would be highly desired – jangorecki Apr 16 '16 at 15:36

score 3 · Answer 3 · answered Dec 08 '12 at 12:39

3

Visual Paradigm for UML can do this.

answered Dec 08 '12 at 12:39

turtledove

25,464
3
23
20

score 2 · Accepted Answer · answered May 08 '09 at 20:05

2

I believe that Embarcadero's ERStudio can import a SQL script into a diagram, but it's a pricey tool to use just for something like this. You could always just create an empty database and run the scripts then point to that.

answered May 08 '09 at 20:05

Tom H

46,766
14
87
128

How to generate Entity-Relation diagram from SQL DDL?

4 Answers4