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 vote238 views1 answer
Sqlite3 not commit
SQL
0 vote275 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
1 vote261 views2 answers
Mysql select tables with name like
SQL
0 vote283 views1 answer
Add mysql database to power bi web
SQL
0 vote215 views1 answer
How to connect sql server using ip address in c#
SQL
3 votes266 views3 answers
Sql last week
SQL
0 vote259 views1 answer
Denormalise SQL command
SQL
0 vote265 views1 answer
Search column name sql
SQL
1 vote282 views2 answers
Postgresql truncate cascade restart identity
SQL
6 votes283 views2 answers
How to get yesterday date in mysql
SQL