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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s