Mysql find foreign key references

SELECT
  TABLE_NAME,
  COLUMN_NAME,
  CONSTRAINT_NAME,   -- <<-- the one you want! 
  REFERENCED_TABLE_NAME,
  REFERENCED_COLUMN_NAME
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE
  REFERENCED_TABLE_NAME = 'My_Table';

Source: grepper.com

Similar codes

-3 votes180 views1 answer
Remove spaces sql 2008
SQL
2 votes199 views1 answer
Oracle convert run_duration to number
SQL
0 vote195 views1 answer
Oracle SQL join three tables and group by column
SQL
-1 vote210 views1 answer
Mysql change database charset and collation
SQL
-1 vote209 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
1 vote195 views2 answers
Begin transaction in sql
SQL
0 vote280 views1 answer
Linux upload database to mysql
SQL
3 votes260 views1 answer
Oracle apex warn on unsaved changes
SQL
7 votes176 views1 answer
Forge server hosting
SQL
3 votes190 views1 answer
How to find names includes in sql
SQL