Tool for convert SQL code to diagram

Question

can any one say some way to convert SQL code to data diagram like ERD ? for som DBMS like MySQL or general SQL

I can't think of a single ERD application that doesn't allow reverse engineering from either a DB or a script. Can you be a little more specific? Do you currently have an ERD application that you're using? What format do you want it in? — Tom H, May 14 '10 at 19:47
I need a tool convert sql code ( create table ) to diagrams like ERD (ERD not important ) — Sajad Bahmani, May 14 '10 at 19:52

score 15 · Answer 1 · answered Sep 01 '18 at 08:50

15

using mysql Workbench do the following:

1- file -> new model

2- file -> import -> reverse engineer mysql create script

select ur mysql file script

and tick on place imported objects on a diagram

and press next and finish

answered Sep 01 '18 at 08:50

Ahmed M. Matar

514
1
5
13

1

Thanks man! Worked for me, even with dockerized workbench https://hub.docker.com/r/openkbs/mysql-workbench/ – JRichardsz Dec 11 '19 at 20:28

score 4 · Answer 2 · edited Jul 13 '15 at 12:53

4

Use MySQL WorkBench. It's perfect and absolutely compatible with MySQL, Oracle powered!

Check it out here: MySQL Workbench

edited Jul 13 '15 at 12:53

Zev Eisenberg

8,080
5
38
82

answered Dec 11 '12 at 11:25

sstauross

2,602
2
30
50

score 2 · Answer 3 · answered May 14 '10 at 19:54

ModelRight, http://www.modelright.com/ , is a good ERD application and is free for MySQL and ODBC connected databases. It reverse engineers from a DB, if you want to reverse engineer from SQL Script, you should check out Dezign for Databases, http://www.datanamic.com/

score 2 · Accepted Answer · answered May 18 '10 at 11:03

For MySQL can use sqlyog :

SQLyog MySQL GUI is the most powerful MySQL manager and admin tool, combining the features of MySQL Query Browser, Administrator, phpMyAdmin and other MySQL Front Ends and MySQL GUI tools in a single intuitive interface.

http://www.webyog.com/en/

Tool for convert SQL code to diagram

4 Answers4