How to find tables all relation in MySQL

Question

How to find tables all relation in MySQL. whether it references some table, or some other table will take its reference.

For example, suppose student is a table which contains id (primary key), name, class(Foreign key refers class table id field) element. And class is an another table which contains id(primary key), name. and another table student_account is an another table which contains id(primary key), student_id(Foreign key refers student table id field),due.

Now how may I find all relation of table student.

Thanks looks like a bit helpful. – Alok Kumar Mishra Nov 21 '15 at 05:16 — Alok Kumar Mishra, Nov 21 '15 at 05:16

score 1 · Accepted Answer · answered Nov 21 '15 at 06:07

1

You can try this.

 SELECT TABLE_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
 FROM information_schema.KEY_COLUMN_USAGE WHERE CONSTRAINT_SCHEMA = Your_Table_Name
 AND REFERENCED_TABLE_SCHEMA IS NOT NULL AND REFERENCED_COLUMN_NAME IS NOT NULL AND
 REFERENCED_TABLE_NAME IS NOT NULL

answered Nov 21 '15 at 06:07

Shashank Singh

1,280
12
23

"Your_table_name" should read "Your_schema_name" in the restriction for this to work. – Paul Campbell Dec 27 '17 at 14:23

How to find tables all relation in MySQL

1 Answers1

Linked