How to create an Entity-Relation diagram from SQL DDL?

For example, DbVisualizer can be used to connect to a database and create a good chart from existing tables and their relationships. But in this particular case, I do not have a live database, but I have a set of create and alter commands.

Is there any tool for creating similar diagrams from SQL DDL?

+5
source share
4 answers

I believe that Embarcadero ERStudio can import an SQL script into a chart, but it is an expensive tool to use just for something like that. You can always simply create an empty database and run scripts and then point it out.

+2

MySQL MySQL Workbench . Mac OS X. http://dev.mysql.com/doc/index-gui.html.

+7

SQLFairy will generate graphics from simple SQL DDL files:

http://sqlfairy.sourceforge.net/

+4
source
+2
source

All Articles