Need a select statment for getting record count for all the tables

• NirmalKatta

  Old Hand

  Points: 326

  More actions

  November 6, 2007 at 1:46 pm

  #183611

  Need a select statement for getting record count for all the tables, I have only read access on the server , so no Temp tables or SP creation is not permitted. Help appreciated:)

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  November 6, 2007 at 3:02 pm

  #748889

  You can try this:

  exec sp_MSforeachtable 'select ''?'' as TableName, count(*) as RecordCount from ?'

  I'm sure others will come up with other solutions as well. 😉