sp_MSforeachtable to return tablename AND rowcount

• Express12

  SSCoach

  Points: 18514

  More actions

  April 6, 2006 at 10:01 am

  #112797

  Need this SQL to return both the TableName AND rowcount.  Any ideas?  (as is, only returns the RowCount)

   sp_MSforeachtable @command1="select count(*) from ?"

  BT

• Eddie Wuerch

  SSChampion

  Points: 12535

  More actions

  April 6, 2006 at 10:28 am

  #631303

  sp_MSforeachtable @command1="select count(*), '?' from ?"

   

  Eddie Wuerch
  MCM: SQL