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 vote187 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
0 vote196 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
8 votes227 views1 answer
Mysql limit rows
SQL
3 votes273 views1 answer
Apex call duration
SQL
0 vote216 views1 answer
Check if mysql db is used
SQL
4 votes186 views1 answer
Wilayah indonesia sql
SQL
3 votes200 views4 answers
Stop MySQL
SQL
0 vote196 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
0 vote208 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
-3 votes198 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL