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

19 votes145 views4 answers
Rename database in sql
SQL
0 vote151 views1 answer
Update one column from another column in same table
SQL
0 vote147 views1 answer
Mysql query to check record exists in database table or not
SQL
0 vote141 views3 answers
How to verify sequence result in oracle SQL
SQL
6 votes177 views6 answers
Rename column postgres
SQL
32 votes158 views6 answers
Insert into values select
SQL
0 vote149 views1 answer
SQL Server modify_timestamp trigger
SQL
0 vote175 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
17 votes173 views6 answers
MySQL ORDER BY
SQL
0 vote313 views1 answer
The package java.sql is not accessible
SQL