Microsoft - Microsoft SQL Server - SQL - Constraints

Disable all table constraints

Disable single constraint

Enable all table constraints

Enable single constraint