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

2 votes324 views2 answers
MySql FULL OUTER JOIN
SQL
0 vote234 views1 answer
Count column of tables psql
SQL
4 votes268 views4 answers
Oracle tablespace tables list
SQL
3 votes266 views1 answer
Oracle sql commit example
SQL
1 vote234 views1 answer
Sql comment header
SQL
2 votes272 views1 answer
Oracle generated column
SQL
2 votes248 views1 answer
Create table with primary key
SQL
0 vote269 views2 answers
Script all indexes in a database
SQL
0 vote263 views1 answer
Flexible search query delete table
SQL
6 votes279 views2 answers
Sql sequence
SQL