Visualizing InnoDB's Foreign Keys

Question

What would be the best way to get a visual representation of a group of MySQL tables' foreign key constraints? (other than drawing them out by hand)

Something like this:

_{(source: postgresonline.com)}

score 2 · Accepted Answer · answered Oct 25 '09 at 01:51

2

Use MySQL Workbench

answered Oct 25 '09 at 01:51

Please describe what feature of the workbench to use – Simulant Nov 17 '17 at 14:07

score 0 · Answer 2 · answered Oct 24 '09 at 17:39

0

SQLFairy should be able to produce a number of different graphical outputs (as well as translating between different dialects of SQL). You should be able to produce what you're looking for using those.

answered Oct 24 '09 at 17:39

David Pashley

23,151
2
41
71

Visualizing InnoDB's Foreign Keys

2 Answers2