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 ...