Digital Marketing

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

Comments

Popular posts from this blog

MySQL Sandbox with the Sakila sample database