Tuesday, March 20, 2012

Switch Off Foreign Key Constraint

I used to use this code regularly but when i found it for the first time it took me to read many pages to read after getting the code i thought this would be useful for all people like me who want to Switch off the Foreign key Constraint in their tables

This is helpful when you are actually want to create tables irrespective of the Foreign key constraint 

To Turn Off - SET FOREIGN_KEY_CHECKS = 0;

To Turn On - SET FOREIGN_KEY_CHECKS = 1;