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

• Sal Young

  Mr or Mrs. 500

  Points: 567

  More actions

  September 24, 2007 at 2:19 pm

  #735764

  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

  December 18, 2007 at 2:14 am

  #760922

  :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

  December 18, 2007 at 9:01 pm

  #761284

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