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

0 vote238 views1 answer
Mysql drop trigger
SQL
24 votes264 views4 answers
Postgres delete database
SQL
6 votes244 views1 answer
Oracle list primary key
SQL
1 vote270 views5 answers
Postgresql difference between two dates in days
SQL
0 vote224 views1 answer
How to find top 3 salary in sql
SQL
1 vote193 views1 answer
Restart identity postgresql
SQL
0 vote240 views1 answer
Sql sum show 0 result
SQL
0 vote238 views1 answer
Mysql match in serialized data
SQL
0 vote218 views1 answer
Mysql with
SQL
0 vote238 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL