I usually do it in scenarios where I don't want a time consuming process to fail because one or a few of many million rows have bad data in it. I sometimes disable constraint checking on tables during data loads from external sources or when I need to script a table drop/recreate with reloading the data back into the table. There are certain scenarios though where it is useful to temporarily turn them off because their behavior is either not needed or could do more harm than good. Which is now archived in the Wayback Machine)įoreign key constraints and check constraint are very useful for enforcing data integrity and business rules.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |