How to generate Entity-Relation diagram from SQL DDL?

sql database-design ddl er-diagrams
Petteri H picture Petteri H · May 8, 2009 · Viewed 24.9k times · Source

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?

Answer

ahalls picture ahalls · May 7, 2011

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.

Related questions

Safely rename tables using serial primary key columns

I know that PostgreSQL tables that use a SERIAL primary key end up with an implicit index, sequence and constraint being created by PostgreSQL. The question is how to rename these implicit objects when the table is renamed. Below is …

Read More
Superkey vs. Candidate key

What difference between Super and Candidate key in ERDB?

Read More
Remove Primary Key in MySQL

I have the following table schema which maps user_customers to permissions on a live MySQL database: mysql> describe user_customer_permission; +------------------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+---------+------+-----+---------+…

Read More