Posts Tagged ‘Tips

— Disable all the constraints in database EXEC sp_msforeachtable “ALTER TABLE ? NOCHECK CONSTRAINT all” EXEC sp_msforeachtable “delete from ? ” — Enable all the constraints in database EXEC sp_msforeachtable “ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all”


top