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 vote185 views1 answer
Python dictionary to sql update
SQL
1 vote194 views1 answer
Moodle query first user access
SQL
0 vote181 views1 answer
C# execute transact sql
SQL
0 vote188 views1 answer
Postgres clear table
SQL
0 vote259 views2 answers
Search stored procedures by name
SQL
2 votes161 views1 answer
Sql alchemy or
SQL
0 vote174 views1 answer
Mysql foreach insert
SQL
0 vote181 views1 answer
Copy data from one postgres container to another
SQL
0 vote160 views1 answer
Oracle list index on table
SQL
0 vote225 views1 answer
How to compile a function in oracle
SQL