# Records in Table BY Table Entire database

• texpic

  SSCertifiable

  Points: 5885

  More actions

  January 15, 2005 at 10:14 am

  #87270

  How would I do this in a stored procedure?

  SELECT COUNT (*), TableName

  FROM DATABASE LotsOfTables.MDF

   

  I have a database that I'm reviewing that has about 400 tables, but my guess is 20 are used, LOL.  I'd like to use Query Analyzer to get the TableName and Count.  Thanks

   

• Kathi Kellenberger

  SSChampion

  Points: 11811

  More actions

  January 15, 2005 at 12:45 pm

  #537579

  Here is an easy way to do it:

  sp_msforeachtable @command1= 'print ''?''', @command2 = "select count(*) from ?"

  I found this in

  http://qa.sqlservercentral.com/columnists/rsharma/countrecords.asp

  It only works on user (non-system) tables and set the "Execute Mode" to "Results in Text"

   

  Aunt Kathi Data Platform MVP
  Author of Expert T-SQL Window Functions
  Simple-Talk Editor