15 September 2010

Count number of tables in a SQL Server database

Count number of tables in a SQL Server database

USE YOURDBNAME
SELECT COUNT(*) from information_schema.tables
WHERE table_type = 'base table'
-
Labels:

No comments:

Post a Comment

Comments Welcome

Subscribe to: Post Comments (Atom)

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...