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 are Wait Types in SQL Server ?

Using CASE WHEN in MS SQL

What are The Different Backup Options With SQL Server ?

Listing Metadata of MS SQL Server Internal Tables

What is Change Data Capture in SQL Server ?