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

1 vote186 views1 answer
How to check all scheduled jobs in oracle
SQL
1 vote217 views1 answer
Alter constraint postgres
SQL
1 vote164 views1 answer
Count of tables in database mysql
SQL
0 vote140 views1 answer
Mysql xampp reset root password
SQL
0 vote143 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
0 vote168 views1 answer
When mysql server would not work in xampp
SQL
0 vote167 views1 answer
Enlever les doubles espaces dans les tables postgresql
SQL
0 vote158 views1 answer
Sql server current time without date
SQL
2 votes133 views1 answer
Install sqlite npm
SQL
0 vote137 views1 answer
Concatenate columns in table
SQL