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

5 votes126 views1 answer
Oracle create table comment
SQL
7 votes154 views1 answer
Show line number in sql server
SQL
0 vote115 views1 answer
Comma seperated join mssql
SQL
0 vote128 views1 answer
Oracle last connexion
SQL
7 votes121 views3 answers
Postgre describe table
SQL
1 vote109 views1 answer
Reutrn string after character sql
SQL
0 vote122 views1 answer
Sql query to force the database to be drop
SQL
3 votes125 views2 answers
Monthname sql
SQL
2 votes143 views1 answer
Sql string starts with
SQL
1 vote111 views1 answer
Psql datetime grather than
SQL