How to know relations between tables
<p>I have a database in MySQL created by someone. I don't have any documentation of the database. </p>

<p>How can I know the relationship between the tables? </p>

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

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