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