There are times when you may want to disable all the constraints in the your SQL Server Database tables when importing the data from the external data source .

How to Disable All Constraints in the Database temporarily in SQL Server ?

Below is a sample query that lets you to quickly disable the constraints like foreign keys , unique keys etc for the database tables.

EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"

Simple isn’t it ?

Leave a Reply

Your email address will not be published. Required fields are marked *

Liked this content?. Please spread the word :)

  • RSS
  • Twitter
    Visit Us
    Follow Me