2

I am trying to create a graphical representation of table relations using "Mysql workbench".

I double clicked on "MySQL Model" tab and added Diagram.

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

Improve this question

1 Answer 1

Reset to default
5

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

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

If you mean you want to reverse engineer your existing database, then you can do so as follows:

On the "Database" menu, there is a "Reverse Engineer" wizard. It will let you connect to a MySQL server and reverse engineer schemata. Then you can create diagrams from those database objects. You can also use the "Forward Engineer" wizard, which generates and executes SQL DDL statements based on your diagrams.

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

>> On the "Database" menu, there is a "Reverse Engineer" wizard. It will let you connect to a MySQL server and reverse engineer schemata. Thank you very much. I wasted several hours but could not figure it out!
Is there any way I can appreciate the answer? I have clicked on the up arrow and accepted the answer by clicking on the correct sign. But I guess that is not enough for saving a few hours trying to figure out that was so easy to achieve.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.