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

2 votes231 views1 answer
Search query in mysql
SQL
0 vote208 views1 answer
Sql find table by name
SQL
0 vote227 views1 answer
Running mysql from bash sc
SQL
0 vote210 views1 answer
Sql count more than 1
SQL
0 vote207 views1 answer
Sqlite update only if greater
SQL
0 vote189 views1 answer
Postgresql inline table
SQL
5 votes233 views2 answers
Mysql create database charset utf8mb4
SQL
0 vote226 views1 answer
Python list from sql
SQL
0 vote237 views1 answer
Get role postgres
SQL
3 votes196 views1 answer
What is having clause
SQL