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

4 votes210 views4 answers
Update select mysql
SQL
0 vote128 views1 answer
Sql query to force the database to be drop
SQL
2 votes117 views1 answer
Sql like variable
SQL
1 vote124 views1 answer
Count mysql server db tables
SQL
1 vote109 views4 answers
Sql now
SQL
0 vote123 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
3 votes144 views3 answers
Restart mysql mac
SQL
0 vote128 views1 answer
Declarative base sqlalchemy
SQL
1 vote132 views1 answer
Mysql show database size in mb
SQL
9 votes123 views4 answers
How to create new user and database postgresql in ubuntu
SQL