Display Row Count for 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 Cade Bryant » Display Row Count for all Tables

Display Row Count for all Tables

Rate Topic

Display Mode

Topic Options

Author

Message

cadebryant

Posted Saturday, September 22, 2007 8:48 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, November 05, 2008 2:49 PM
Points: 57, Visits: 14

Comments posted to this topic are about the item Display Row Count for all Tables

Post #401413

Sal Young

Posted Monday, September 24, 2007 2:19 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, March 30, 2013 2:45 PM
Points: 108, Visits: 273

cadebryant (9/22/2007)

Comments posted to this topic are about the item Display Row Count for all Tables

You could also use the system stored procedure sp_spaceused 'YourTableName' . I actually saved this and other system stored procedures on my "Keyboard Shortcuts" for easy access.

Sal Young
MCITP Database Administrator

Post #402226

sarlar

Posted Tuesday, December 18, 2007 2:14 AM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 09, 2008 4:58 AM
Points: 239, Visits: 38

This is not an efficient script, it doesn't include tables without clustered indexes(primary key).

Post #434172

hxd001_810-512717

Posted Tuesday, December 18, 2007 9:01 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, June 03, 2008 8:47 PM
Points: 8, Visits: 18

This script has a fault,that is,the results don't contain those tables which not exists any indexes.

Post #434614

« Prev Topic | Next Topic »

Permissions