CODEWITHSUNDEEP
mysqldatabasemysql-workbench
serge
serge

Reputation: 15219

How to create a Diagram from a MySql database in Workbench?

I need to create to visualize some tables relationship in a diagram.

I use MySql and the MySql Workbench (v6.3). I have a current connection and I ant to see my database tables in a EER diagram like Workbench is supposed to open/create: https://dev.mysql.com/doc/workbench/en/wb-vertical-toolbar.html

But online Oracle documentation seems to be obsolete, for the v5, not for the v6 of workbench, so I wonder if anyone already could build that kind of diagrams in the 6th version of mySql Workbench and how...

I can only create new diagrams via File=>NewModel, but no idea how to generate a diagram from existing database or at least add existing table to a newly created diagram

Upvotes: 3

Views: 12138

Answers (1)

Santosh Jagtap
Santosh Jagtap

Reputation: 1065

  1. Go to to "Database" Menu option
  2. Select the "Reverse Engineer" option.
  3. A wizard will be open and it will generate the ER Diagram for you

OR

Go through the link https://www.youtube.com/watch?v=v5Q0lz5FkW0

Keep in mind MySQL Workbench derives relationships in diagrams from existing foreign keys. If your tables use engines that don't support foreign keys no relationships can be derived automatically.

Upvotes: 16

Related Questions