Mysql show foreign keys column

SELECT 
  TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME
FROM
  INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE
  REFERENCED_TABLE_SCHEMA = '<database>' AND
  REFERENCED_TABLE_NAME = '<table>' AND
  REFERENCED_COLUMN_NAME = '<column>';

Source: stackoverflow.com

Similar codes

0 vote343 views1 answer
How to add timestamp column in mysql
SQL
0 vote368 views1 answer
Python sql last insertend
SQL
0 vote340 views1 answer
Fill up postgres db
SQL
0 vote377 views1 answer
Postgres foreign key multiple columns
SQL
1 vote369 views1 answer
Epoch time converter in snowflake
SQL
0 vote367 views1 answer
Learnxinyminutes sql
SQL
0 vote317 views0 answer
SQL
5 votes331 views1 answer
Oracle nls parameters
SQL
0 vote353 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
-2 votes333 views1 answer
Modify column name in tsql
SQL