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 vote344 views2 answers
Select index table oracle
SQL
-1 vote356 views1 answer
Sql show custom constraints
SQL
1 vote352 views1 answer
Where date = max(date) in sql
SQL
0 vote351 views1 answer
Vowels in sql
SQL
5 votes371 views4 answers
Start postgres server
SQL
0 vote358 views1 answer
Like date sql server not working
SQL
9 votes335 views1 answer
Oracle get table schema
SQL
7 votes351 views2 answers
What is sql clause
SQL
1 vote352 views1 answer
Launch sql script from docker in mysql
SQL
0 vote352 views1 answer
Interview experience as a call?
SQL