Generate ERD from SQLyog

Question

is there a way for me to generate an Entity Relationship Diagram (ERD) from SQLyog? or if not, from PHPmyAdmin of XAMPP? thanks!

score 6 · Answer 1 · edited May 23 '17 at 11:47

6

SQLyog has this feature- Schema designer, which is a visual interface where tables and table structures can be defined, displayed and manipulated. But Schema Designer is not a full featured ERD diagramming tool. I don't think it is possible to generate from PHPMyAdmin either. You could look into this.

edited May 23 '17 at 11:47

Community

1
1

answered Mar 19 '12 at 06:12

Ashwin A

3,779
23
28

score 4 · Answer 2 · edited Mar 15 '17 at 20:23

4

You can do it in SQLyog. Press Ctrl+Alt+D. This will open the Schema Designer. It's not a very good designer but it works well for simple ERDs.

edited Mar 15 '17 at 20:23

fWd82

840
1
13
31

answered Jun 01 '16 at 08:09

Rabia Naz khan

507
4
13

score 1 · Answer 3 · edited Mar 15 '17 at 18:14

1

SQLYog has a Schema Designer option Ctrl+Alt +D which opens a Schema Designer window.

Right click inside Schema Designer canvas to get small window, select checkbox add tables ( Select all checkboxes if you want all of them on Canvas)

Click Add to get ER diagram of the tables.

edited Mar 15 '17 at 18:14

fWd82

840
1
13
31

answered Jun 20 '13 at 07:22

Praveen Kumar

1,515
1
21
39

score 1 · Answer 4 · edited Mar 15 '17 at 20:39

1

It's Ctrl + Alt + D

Note: It's only for full version.

edited Mar 15 '17 at 20:39

Web_Designer

72,308
93
206
262

answered Oct 15 '13 at 14:23

Harshil

119
1

score 1 · Answer 5 · answered Mar 05 '14 at 10:36

1

Yes you can generate ERD with PHPMyAdmin. PHPMyadmin added this functionality from version 3.4

detail step to generate ERD : http://goo.gl/0z3vFE

You can refer to PHPMyAdmin documentation for more info: http://www.phpmyadmin.net/documentation/#pmadb

answered Mar 05 '14 at 10:36

Suresh Kamrushi

15,627
13
75
90

Generate ERD from SQLyog

5 Answers5