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

1 vote226 views3 answers
Postgresql get difference between two dates
SQL
0 vote212 views1 answer
Display first three characters sql
SQL
0 vote212 views1 answer
Find and replace query in wordpress\
SQL
0 vote253 views1 answer
How to pass list as parameter in SQL query
SQL
0 vote209 views1 answer
Mysql db dump restore max file size issue
SQL
1 vote218 views1 answer
Postgresql filter on
SQL
0 vote237 views1 answer
Sql multiple into
SQL
0 vote204 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
5 votes229 views4 answers
Traduction
SQL
1 vote205 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL