Here is a small query to display all foreign keys across different databases. May come in very handy when deciding which database to restore first :)
USE information_schema;
SELECT *
FROM
KEY_COLUMN_USAGE
WHERE
CONSTRAINT_SCHEMA != REFERENCED_TABLE_SCHEMA;
No comments :
Post a Comment