MySQL: How to check foreign keys related to a table

SELECT
  TABLE_NAME,
  COLUMN_NAME,
  CONSTRAINT_NAME, 
  REFERENCED_TABLE_NAME,
  REFERENCED_COLUMN_NAME
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE
  REFERENCED_TABLE_NAME = 'Your_Table';

Popular posts from this blog

How to delete / clear queue of PowerMTA