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

50 votes450 views6 answers
Sql count duplicate rows
SQL
0 vote331 views1 answer
Sql convert unix time to date
SQL
0 vote316 views1 answer
Monthly Birthday SQL Query
SQL
0 vote324 views2 answers
Mysql on update current_timestamp
SQL
1 vote317 views1 answer
Order by oracle
SQL
5 votes334 views2 answers
Sql server port number
SQL
5 votes305 views2 answers
Mysql drop table cascade
SQL
-1 vote305 views1 answer
How to open blade file from blade in laravel
SQL
1 vote266 views1 answer
Into sql
SQL
0 vote284 views1 answer
Count column of tables psql
SQL