Home Forums Article Discussions Article Discussions by Author Discuss content posted by Girish Patil Row count of all tables RE: Row count of all tables
Adi Lingam-470051
SSC-Addicted
Points: 407
More actions
October 5, 2007 at 10:01 am
#739616
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