Get Row counts of all tables in a database

SELECT sysobjects.name TableName,sysindexes.rows TotalNoRow

FROM sysobjects inner join sysindexes ON sysobjects.id = sysindexes.id

WHERE type = ‘U’AND sysindexes.IndId < 2

order by sysindexes.rows desc

Tagged: Number of table with row count, SQL table with row count in each table, Table and row count