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
I have had so many good people trying to promote various community oriented sites through here. Therefore all comments will first have to come through me... so I get a chance to learn about the interesting sites before you do ...