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 vote209 views1 answer
Sql select sum group by id laravel
SQL
0 vote159 views1 answer
Check if table exists oracle
SQL
0 vote164 views1 answer
Database xml sql
SQL
1 vote168 views1 answer
Check message id sql server
SQL
3 votes160 views1 answer
APEX elapsed time
SQL
0 vote166 views1 answer
Sql offfset
SQL
0 vote181 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
5 votes161 views1 answer
Sqlite alter table add column
SQL
2 votes170 views1 answer
Date_format for time sql
SQL
0 vote245 views1 answer
Having all mysql
SQL