Tag Archives: sql server

How to enable and disable constraints in SQL Server

— Disable all foreign key constraints

EXEC sp_MSforeachtable “ALTER TABLE ? NOCHECK CONSTRAINT ALL”

— Enable all foreign key constraints

EXEC sp_MSforeachtable “ALTER TABLE ? WITH CHECK CHECK CONSTRAINT ALL”