Post reply

Row count of all tables

  • October 5, 2007 at 10:01 am

    #739616

    The following query also gives the same results without creating a table.

    select

    TableName = object_name(id),

    [RowCount] = max(rows)

    from sysindexes

    group by id

  • October 5, 2007 at 10:13 am

    #739623

    This works only if the stats are up to table. It's ok if an estimate is all you need. However if you need accuracy, you need to use count(*).

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply