Using SQL Server Temporarily disabled all check constraints

Temporarily disabled all check constraints:

Classification for disable:

DECLARE @sql NVARCHAR(MAX) = N'';

;WITH x AS
(
  SELECT DISTINCT obj =
      QUOTENAME(OBJECT_SCHEMA_NAME(parent_object_id)) + '.'
    + QUOTENAME(OBJECT_NAME(parent_object_id))
  FROM sys.foreign_keys
)
SELECT @sql += N'ALTER TABLE ' + obj + ' NOCHECK CONSTRAINT ALL;
' FROM x;

EXEC sp_executesql @sql;

For enabling again:

DECLARE @sql NVARCHAR(MAX) = N'';

;WITH x AS
(
  SELECT DISTINCT obj =
      QUOTENAME(OBJECT_SCHEMA_NAME(parent_object_id)) + '.'
    + QUOTENAME(OBJECT_NAME(parent_object_id))
  FROM sys.foreign_keys
)
SELECT @sql += N'ALTER TABLE ' + obj + ' WITH CHECK CHECK CONSTRAINT ALL;
' FROM x;


EXEC sp_executesql @sql;