Mysql show foreign keys

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>';

Source: stackoverflow.com

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

17 votes311 views2 answers
T_sql contains
SQL
0 vote258 views2 answers
Mysql add days to date
SQL
51 votes450 views6 answers
Opera gx
SQL
4 votes257 views1 answer
Oracle delete last row
SQL
0 vote258 views1 answer
Drop a field in psql django
SQL
0 vote257 views1 answer
Mysql select all table that have field names
SQL
0 vote288 views2 answers
How to count codition
SQL
3 votes270 views1 answer
Postgres add not null to existing column
SQL
0 vote327 views1 answer
Oracle convert int to date
SQL
-1 vote261 views1 answer
Mysql #1064 error
SQL