How to create ER Diagram of an existing database using MySQL Workbench
Nov 05 2019 Rishit Patel
The following step-by-step guide will help you create ER Diagram of an existing database using MySQL Workbench very easily.
Open your MySQL Workbench and click on Database. (You can also press Ctrl+R and skip first two steps)
Now click on Reverse Engineer…
Select your database connection and click on Next.
Click on Next when you see fetch finished.
Select the database schema for which you want to create the ER diagram and then click on Next.(You can select multiple databases also)
Also read: The Boot Process
Now, it will retrieve objects from the selected database and check results, after the blue ticks in similar to the image below appear and you see Finished, click on Next.
Now there will be option to select MySQL table objects to reverse engineer, it’s the objects for which you want to create the diagram, After selecting objects click on Execute.(Make sure that checkbox at bottom-left corner labeled as “Place imported objects on a diagram is checked)
Now click on Next.
Click on Close.
Now you will see the ER Diagram of an existing databasethat you have selected.
I hope you will find this tutorial on how to create ER Diagram of an existing database using MySQL Workbench helpful. If you have any suggestions or you need any help feel free to comment in the comment section below.