Showing posts with label Drop all table. Show all posts
Showing posts with label Drop all table. Show all posts

6 September 2011

Sql Server Queries - Disabled all Constrains,Drop all table,Enable all Constraints in Sql Server

--Disabled all constrains in sql server
EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"

--Drop all table in Database
EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"


--Enable all constrains in sql server
exec sp_msforeachtable @command1="print '?'", @command2="ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all"

Consistency level in Azure cosmos db

 Consistency level in Azure cosmos db Azure Cosmos DB offers five well-defined consistency levels to provide developers with the flexibility...