MS SQL List of Records in All Tables

In MS SQL, run the following code to get the list of record numbers of all tables (created by the user) in a database.

SELECT [TableName] = sobj.name, [RowCount] = MAX(sind.rows) FROM sysobjects sobj, sysindexes sind WHERE sobj.xtype = 'U' AND sind.id = OBJECT_ID(sobj.name) GROUP BY sobj.name ORDER BY 2 DESC


You May Interest

What is Deadlock in SQL Server ?

What are Replication and Database Mirroring in SQL Server ?

What is SQL Injection in SQL Server ?

Finding Server Default Language in MS SQL

What is Central Management in SQL Server ?