Get record count for every table in a DB (1 Step)

• Mark-443607

  SSC Veteran

  Points: 254

  More actions

  September 22, 2007 at 1:07 pm

  #177193

  Comments posted to this topic are about the item Get record count for every table in a DB (1 Step)

• kylroa

  Grasshopper

  Points: 11

  More actions

  November 29, 2007 at 8:03 am

  #755458

  cool...

  SELECT o.name TableName ,i.rows TblRowCount

  FROM sysobjects o

  INNER JOIN sysindexes i ON (o.id = i.id)

  WHERE o.xtype = 'u'

  AND i.indid < 2

  order by TblRowCount desc

• Jeff Moden

  SSC Guru

  Points: 1004589

  More actions

  November 29, 2007 at 9:41 pm

  #755793

  Better think about DBCC UPDATEUSAGE once in a while....

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• srihari nandamuri

  Say Hey Kid

  Points: 661

  More actions

  January 26, 2009 at 9:57 am

  #932685

  Below is the best in sql2005

  SELECT object_name(object_id) 'Table_Name', SUM(row_count) 'Total_Rows'

  FROM sys.dm_db_partition_stats where index_id <2 GROUP BY object_name(object_id)

  ORDER BY object_name(object_id)

  Comments please....

  Srihari Nandamuri