i have an existing database and have recently downloaded mysql workbench. I was wondering if anyone could walk me through how to navigate the workbench and how to get a visualization of the RDB. I'd like to know how all the tables are related to each other.
1 Answer
Go to Database Menu
and select Reverse engineer
, or simply press Ctrl+R (Windows) or ⌘+R (OS X).
-
1
-
-
I'll add that this also depends on your database design. We have Hybris eCommerce database and when I went to attempt to reverse engineer it, it had over 1000+ objects, and complained until I drastically reduced that number to around 100 which defeats the purpose. And, even after filtering it down to a core 100 objects (customers, carts, orders, shipping) the cards were still a mess and didn't create an interesting map that I could easily explore. Sep 23, 2022 at 14:36