Clever Geek Handbook

Using MySQL Workbench

I am trying to create a graphical representation of tabular relationships using "Mysql Workbench".

I double clicked on the MySQL Model tab and added a diagram.

But I cannot figure out how to display tables from the current DB. Any help?

+2


source to share


1 answer


I'm not sure what you mean by "current DB".

If you mean the existing tables in the "current MySQL Workbench model" then make sure the Catalog window is visible (View => Windows => Catalog) and you can drag tables to the canvas.



If you want to reverse engineer an existing database, then you can do it like this:

There is a Reverse Engineer wizard in the Database menu. This will allow you to connect to MySQL server and reverse engineering diagrams. Then you can create diagrams from these database objects. You can also use the Forward Engineer wizard, which generates and executes SQL DDL statements from your diagrams.

+5


source






More articles:


All Articles