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

You need to view when in the command prompt. I understand the associations stored in the database information_scheme. But where and what is the query you need to create?
July 9th 19 at 13:08
4 answers
July 9th 19 at 13:10
Solution
July 9th 19 at 13:12
Solution
SELECT TABLE_NAME, COLUMN_NAME, CONSTRAINT_NAME,
REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE TABLE_NAME LIKE "MY_TABLE";
July 9th 19 at 13:14
Look for a program that is able to do "reverse" engineering MySQL database... (name unfortunately forgotten!)
This aplikuju you almost masterpiece will make a picture :)
Dig to the side - dit.isuct.ru/Publish_RUP/core.base_rup/guidances/t...
(Alas, MySQL is not mentioned)
July 9th 19 at 13:16
If these relationships are not formalized in an explicit form via a FOREIGN KEY, then they are stored only in the mind of the programmer or maybe even in the product documentation. A FOREIGN KEY can be obtained using SHOW CREATE TABLE `table_name`;

Find more questions by tags cmd/batMySQL