Clever Geek Handbook

Is there a tool that can visually display table relationships in MySQL?

I am looking for a tool that can display relationships in my database in mysql. I would like something like a view that is created in MS-SQL Server Management Studio in the Show Diagram Pane. Is there such a thing?

I am responsible for the design of the database and its use of conventions. I would not negatively specify the relationship manually.

+1


source to share


6 answers


Doesn't MySQL Toad have a schema diagram tool? I think it is. I'm not a charting guy (much happier with the release of mysqldump), but I've worked with a lot of people who swear by Toad.



+2


source


Maybe the official tool has this?



http://dev.mysql.com/downloads/workbench/5.1.html

+2


source


MySQL Workbench 5.1.16 does not work on my OS X 10.5.7 system. I found that it does something like crashing and disappears without error. Or it will be an error when trying to resize the page in the print settings. In the meantime, there is no need to know about it. ”

I also tried running it on Windows XP under VMWare. It seemed more stable and comfortable there. I was able to redo the DB and create a diagram.

+1


source


I used DBVis together with Oracle a year ago . He believes that he also works with MySql.

0


source


Altova DatabaseSpy will show them if you are on Windows. If not, the easiest way is to query INFORMATION_SCHEMA (if you are using v5 or newer MySQL) and check the keyword column usage statistics for all tables. This is an easy script to do.

0


source


Most MySQL databases still use MyISAM tables, which do not provide foreign key constraints. Without explicit FKs, you can best guess the relationship between tables.

-2


source






More articles:


All Articles