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

4 votes238 views2 answers
Convert utc to est sql
SQL
0 vote235 views1 answer
How do you insert boolean to postgresql
SQL
-1 vote161 views1 answer
Search all database tables for a value sqlserver
SQL
4 votes298 views1 answer
Oracle table statistics
SQL
0 vote163 views2 answers
Mysql output csv
SQL
3 votes175 views1 answer
Sql replace character in string in all records
SQL
0 vote156 views1 answer
Postgresql create user roles
SQL
7 votes171 views1 answer
Connect mysql docker
SQL
0 vote169 views1 answer
Login failed for login due to trigger execution
SQL
0 vote161 views1 answer
Get week day name sql server
SQL