NDS Care - Customer Support Portal
            Knowledge Base NDS Knowledgebase SQL

            How to enable and disable Table Constraints

            - Disable all table constraints
            ALTER TABLE YourTableName NOCHECK CONSTRAINT ALL
            -- Enable all table constraints
            ALTER TABLE YourTableName CHECK CONSTRAINT ALL
            -- ----------
            -- Disable single constraint
            ALTER TABLE YourTableName NOCHECK CONSTRAINT YourConstraint
            -- Enable single constraint
            ALTER TABLE YourTableName CHECK CONSTRAINT YourConstraint

            Note: Don't forget to Enable all the table constraints after job done.
            Updated: 20 Sep 2017 02:00 PM
            Helpful?  
            Help us to make this article better
            0 0