Enable/Disable constraints on table

-- Disable all constraint on table

Alter table [table_name] nocheck constraint all

-- Enable all constraint on table:

Alter table [table_name] check constraint all -- do not check existing data

Alter table [table_name] with check check constraint all -- check existing data