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

5 votes129 views1 answer
Sql select ciunt
SQL
16 votes142 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
0 vote135 views1 answer
Lesser than or equal to symbol in postgres
SQL
1 vote137 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
1 vote140 views1 answer
Oracle case
SQL
10 votes152 views1 answer
How to import database in mysql by cmd
SQL
0 vote157 views1 answer
Getting next sequence value jpa postgress
SQL
2 votes141 views1 answer
No data found oracle
SQL
25 votes127 views1 answer
Mysql grant all privileges to a user
SQL
0 vote148 views1 answer
Limit in access query
SQL