Mysql show foreign keys column

SELECT 
  TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME
FROM
  INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE
  REFERENCED_TABLE_SCHEMA = '<database>' AND
  REFERENCED_TABLE_NAME = '<table>' AND
  REFERENCED_COLUMN_NAME = '<column>';

Source: stackoverflow.com

Similar codes

0 vote255 views2 answers
How to login to mysql as normal user in ubuntu
SQL
0 vote297 views1 answer
Min varias colunas spark sql
SQL
0 vote260 views2 answers
How to list all values of a column that start with a letter in sql
SQL
-1 vote257 views1 answer
Partial search in sql
SQL
0 vote212 views1 answer
Mysql convert column to uppercase
SQL
1 vote272 views1 answer
How to fetch alternate records from two tables
SQL
32 votes268 views6 answers
Sql count where
SQL
1 vote249 views1 answer
Apex run 404
SQL
0 vote258 views1 answer
Except in sql alchemy
SQL
0 vote265 views2 answers
Postgres show current role
SQL