Easy as: sp_msforeachtable ‘ALTER TABLE ? NOCHECK CONSTRAINT all’ GO sp_msforeachtable ‘DELETE ?’ GO sp_msforeachtable ‘ALTER TABLE ? CHECK CONSTRAINT all’ GO