How to get ER model of database from server with Workbench

mysql entity-relationship mysql-workbench
zdarsky.peter picture zdarsky.peter · Mar 6, 2012 · Viewed 138.2k times · Source

Is there any way to get an ER model of a database from the server that is connected to my MySQL Workbench?

Answer

Kamran Ali picture Kamran Ali · Mar 6, 2012
  1. Go 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.

Related questions

Tool for convert SQL code to diagram

can any one say some way to convert SQL code to data diagram like ERD ? for som DBMS like MySQL or general SQL

Read More
Deciding on foreign key while implementing one to one relationship in MySQL

I have two simple tables "items" and "orders". For the sake of simplicity lets assume that one item can only be in one order or one order can only contain one item. Now as this can be implemented using simple …

Read More
MySQL: Finding rows that don't take part in a relationship

I have two tables: 'movies' and 'users'. There's an n:m relationship between those, describing what movies a user has seen. This is described with a table 'seen' Now i want to find out for a given user, all the …

Read More