Home Forums SQL Server 7,2000 Administration Use sp_MSforeachtable to gen COUNT(*) for each table in MyDBname RE: Use sp_MSforeachtable to gen COUNT(*) for each table in MyDBname

  • May 26, 2016 at 11:41 am

    #1881629

    This worked for me:

    use <dbname>

    go

    exec sp_msforeachtable 'SELECT COUNT(*) FROM ?;'