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

Using MS SQL If Else

Where are SQL Server Usernames and Passwords Stored in the SQL Se ...

Differences Between Stored Procedure and Function in MS SQL

What is an Online Rebuilding of Indexes in SQL Server ?

What are the System Data Collection Sets Predefined Inside SQL Se ...