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 vote150 views1 answer
Go install mysql
SQL
0 vote156 views1 answer
Insert overwrite table in mysql in nifi
SQL
0 vote150 views1 answer
Access refused mysql xampp server
SQL
1 vote153 views1 answer
Drop function
SQL
0 vote156 views1 answer
Mysql_num_fields in mysqli
SQL
5 votes156 views1 answer
Oracle sysdate
SQL
0 vote181 views1 answer
For row in sql database python loop
SQL
0 vote173 views1 answer
SQL Query to delete all the tables in a database
SQL
0 vote157 views1 answer
List all indexes postgres
SQL
15 votes144 views2 answers
Install mysql 8 ubuntu 18.04
SQL