Display Row Count for all Tables

Question

Display Row Count for all Tables

cadebryant

Ten Centuries

Points: 1045
More actions
September 22, 2007 at 8:48 am

#69184

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

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

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

Sal Young Mr or Mrs. 500 Points: 567 More actions · Answer 1

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.

[font="Verdana"]Sal Young[/font]
[font="Verdana"]MCITP Database Administrator[/font]

sarlar Old Hand Points: 307 More actions · Answer 2

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

hxd001_810-512717 SSC Journeyman Points: 86 More actions · Answer 3

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