Answers for "mysql find foreign key references"

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';

Posted by: Guest on June-17-2021

Code answers related to "mysql find foreign key references"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "mysql find foreign key references"

Code answers related to "mysql find foreign key references"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "mysql find foreign key references"

Code answers related to "mysql find foreign key references"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us