Number of rows on each table in a DB

• bruce_reid

  SSCrazy

  Points: 2419

  More actions

  December 1, 2003 at 10:28 am

  #81676

  How can I get the Number of rows on each table in a DB.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736479

  More actions

  December 1, 2003 at 11:54 am

  #484146

  There are some scripts in our script library that can do this.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

  The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

  http://www.dkranch.net

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  December 1, 2003 at 2:36 pm

  #484165

  For some big tables it would be faster to get that number from the row column of the sysindexes table.