MySQL. How to view data schema (relationships between tables)?

Question

MySQL

You need to view the connections on the command line . As far as I understand, the link data is stored in the information_scheme database . But where exactly and what request should be created?

Answer 1

dba.stackexchange.com/a/102374

Answer 2

Look for a program that can do "reverse" engineering of a MySQL database... (unfortunately I forgot the name!)
Such an application will practically make you a masterpiece in the form of a picture :)
Dig aside - dit.isuct.ru/Publish_RUP/core.base_rup/guidances /t...
(MySQL, alas, is not mentioned)

Answer 3

If these links are not formalized explicitly through FOREIGN KEY, then they are stored only in the programmer's head, or even in the product documentation. And FOREIGN KEY can be obtained throughSHOW CREATE TABLE `table_name`;