How to view table relationships in SQL?

Question

MySQL

There is a very complex and confusing database. You need to see which tables the target table is associated with. How can this be done without knowing their names?
It is highly desirable that it be in a convenient visual form.
An interesting solution for MySQL and PostgresSQL
I use Navicat

Answer 1

Solved the issue with DbShema. Highly recommend.

Answer 2

If relationships are organized as foreign keys, then MySQL Workbench has Reverse Engeneer, which shows them on the EER diagram, most likely in Navicat too. If the connections were only in the developer's head, then look at all the tables and try to guess by the names of the fields what is what.