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

2 votes197 views1 answer
Mysql Incorrect column specifier for column
SQL
4 votes214 views2 answers
Xampp mysql database server is not starting mac m1
SQL
0 vote197 views1 answer
Mssql current date
SQL
5 votes208 views2 answers
Sql constraint check value in list
SQL
0 vote238 views1 answer
Pl sql search in all packages
SQL
10 votes312 views4 answers
Sql server pagination
SQL
0 vote193 views1 answer
Syntax for changing column size in mysql
SQL
9 votes216 views1 answer
Alter table column change data type to text mysql
SQL
0 vote239 views1 answer
How to subquey to do not load in live database in
SQL
0 vote158 views1 answer
Get last run query sql server
SQL