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 an OUTPUT Clause Inside SQL Server ?

Using MS SQL DISTINCT

What are Wait Types in SQL Server ?

MS SQL Show Only Date of Current Time

Using CASE WHEN in MS SQL