Reputation: 61
1 click Mysql schema to diagram convert?
I have so many tables and FK relationships it is hard to keep track and visualze it all. Speard across multiple excel documents. I have it already entered in mysql but I want to output a data model diagram that links tables together along with all the FKs.
How to do it apart from manually having to do it? I am open to 3rd part tools as long as they are free.
Upvotes: 3
Views: 2384
Answers (2)
Reputation: 43619
Well I am using phpMyAdmin on my local server.
phpMyAdmin 3 has this Designer feature that shows you the linkages between various tables and its columns.
Upvotes: 1
Reputation: 5377
Take a look at the MySQL Workbench.
It's a free tool and offers a few nice features like forward and backward engineering and database synchronisation. I has a few bugs, but its the best tool for MySQL I know so far.
Upvotes: 0
Related Questions
- Tool for convert SQL code to diagram
- How to create a Diagram from a MySql database in Workbench?
- How can I make class diagram from the database diagram?
- MySQL Workbench generate diagrams out of data
- how to convert mysql database to class diagram
- Translating diagram to SQL Database
- Create database schema diagram from .sql file for mysql
- Is there a simple way to directly convert Web-based MySQL DB into ER Diagram?
- Database modeling tool to generate E-R diagrams from schema or any other tool to visually represent the MySQL DB schema
- How to generate database diagram automatically? mysql