Row count of all tables

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Adi Lingam-470051 SSC-Addicted Points: 407 More actions · Answer 1

The following query also gives the same results without creating a table.

select

TableName = object_name(id),

[RowCount] = max(rows)

from sysindexes

group by id

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 2

This works only if the stats are up to table. It's ok if an estimate is all you need. However if you need accuracy, you need to use count(*).

Cookies on SQLServerCentral