Row count of all tables

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Girish Patil » Row count of all tables

Row count of all tables

Rate Topic

Display Mode

Topic Options

Author

Message

Girish Patil

Posted Tuesday, September 25, 2007 12:12 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, January 02, 2009 2:41 PM
Points: 110, Visits: 20

Comments posted to this topic are about the item Row count of all tables

Post #402691

Adi Lingam-470051

Posted Friday, October 05, 2007 10:01 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, July 12, 2012 2:43 PM
Points: 399, Visits: 67

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

Post #407452

Ninja's_RGR'us

Posted Friday, October 05, 2007 10:13 AM

SSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 5:19 AM
Points: 21,357, Visits: 9,530

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(*).

Post #407461

« Prev Topic | Next Topic »

Permissions