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 vote159 views1 answer
GROUP BY clause; this is incompati
SQL
3 votes175 views1 answer
Unsigned int in mysql
SQL
2 votes167 views1 answer
How to create sql database
SQL
2 votes175 views1 answer
Find all triggers in database
SQL
2 votes155 views2 answers
Select multiple tables mysql
SQL
1 vote137 views1 answer
Python escape string for sql
SQL
0 vote188 views2 answers
Insert data mysql with cmd
SQL
0 vote171 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
0 vote171 views1 answer
How to Remove milliseconds from Date time
SQL
10 votes181 views6 answers
Mysql delete duplicates
SQL