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 vote108 views1 answer
Mysql pad zeros
SQL
4 votes57 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL
0 vote96 views1 answer
Change date format in oracle query
SQL
2 votes100 views2 answers
Mysql get time from datetime
SQL
2 votes121 views3 answers
Sql interview query questions
SQL
5 votes116 views1 answer
Oracle add time to date
SQL
0 vote71 views1 answer
Postgres create database if not exists
SQL
0 vote109 views1 answer
Sql auto_increment syntax
SQL
0 vote100 views1 answer
Drop specific row postgresql
SQL
1 vote94 views2 answers
Mysql order by date asc null last
SQL