Fast Table Counts

Query to return the number of rows for each table in the database.

SELECT o.name TableName, i.rows TblRowCount

FROM sysobjects o

INNER JOIN sysindexes i ON (o.id = i.id)

WHERE o.xtype = 'u'

AND i.indid < 2

ORDER BY TblRowCount DESC, TableName ASC