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

0 vote102 views1 answer
Composit key in sql
SQL
0 vote122 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
0 vote123 views1 answer
SQL Server date literal
SQL
9 votes109 views4 answers
How to create new user and database postgresql in ubuntu
SQL
16 votes114 views2 answers
Add column if not exists mysql
SQL
3 votes143 views2 answers
Brew restart mysql
SQL
0 vote67 views1 answer
Procedures and functions in pl/sql
SQL
7 votes136 views2 answers
Mysql Public Key Retrieval is not allowed
SQL
0 vote103 views1 answer
Postgresql function ROUND
SQL
1 vote112 views2 answers
Create a unqie constraint mysql
SQL