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 vote231 views1 answer
Drop specific row postgresql
SQL
0 vote228 views1 answer
Mql5 datetime get hour
SQL
0 vote237 views1 answer
Mssql now diff 90 day
SQL
0 vote234 views1 answer
Merge clause with inner join
SQL
1 vote252 views1 answer
Sql server: query to find out all the places where the table is used
SQL
0 vote242 views1 answer
Oracle sql log to console
SQL
0 vote240 views1 answer
Drop column from table if exist on live server mysql
SQL
0 vote229 views1 answer
Sqlite referential integrity
SQL
0 vote185 views1 answer
Connection error in mysql workbench
SQL
1 vote246 views1 answer
Hackerrank sql test solutions
SQL