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

1 vote183 views1 answer
Sqlalchemy order_by
SQL
1 vote185 views1 answer
Psql human readable
SQL
0 vote212 views1 answer
Alternative for LIMIT sql
SQL
1 vote166 views1 answer
Find logged in users mysql
SQL
0 vote206 views1 answer
Sql today at midnight
SQL
1 vote167 views1 answer
Select from describe sql
SQL
5 votes175 views4 answers
Sql check
SQL
22 votes206 views4 answers
Date format mysql
SQL
0 vote177 views1 answer
Sql count total by foreign key
SQL
0 vote195 views1 answer
Max length found in mysql
SQL