Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I aggressively deleted a ton of data after using this query:

SET FOREIGN_KEY_CHECKS = 0;

Is there any easy way I can analyze the entire database to check to see if I have any hanging records that reference foreign keys that no longer exist?

share|improve this question

migrated from serverfault.com Mar 25 at 18:13

This question came from our site for professional system and network administrators.

add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.