How to know relations between tables

mysql database-design wamp entity-relationship entity-relationship-model
Narasimha Maiya picture Narasimha Maiya · Feb 15, 2016 · Viewed 15k times · Source

I have a database in MySQL created by someone. I don't have any documentation of the database.

How can I know the relationship between the tables?

Is there any query or a procedure to generate a report so that it's easy to find the relations?

I can look into Schema information and manually figure it out, but it would be great if I could generate a relationship report.

Answer

Smita Ahinave picture Smita Ahinave · Feb 15, 2016

You can get an overview in MySql Workbench by doing the steps below:

  1. Go to "Database" Menu option.
  2. Select the "Reverse Engineer" option.
  3. A wizard will be opened and will generate an EER Diagram which shows up

Related questions

Remove Primary Key in MySQL

I have the following table schema which maps user_customers to permissions on a live MySQL database: mysql> describe user_customer_permission; +------------------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+---------+------+-----+---------+…

Read More
Auto Generate Database Diagram MySQL

I'm tired of opening Dia and creating a database diagram at the beginning of every project. Is there a tool out there that will let me select specific tables and then create a database diagram for me based on a …

Read More
What is the ideal data type to use when storing latitude / longitude in a MySQL database?

Bearing in mind that I'll be performing calculations on lat / long pairs, what datatype is best suited for use with a MySQL database?

Read More