Home Forums Article Discussions Article Discussions by Author Discuss content posted by Mark Get record count for every table in a DB (1 Step) RE: Get record count for every table in a DB (1 Step)

  • November 29, 2007 at 8:03 am

    #755458

    cool...

    SELECT o.name TableName ,i.rows TblRowCount

    FROM sysobjects o

    INNER JOIN sysindexes i ON (o.id = i.id)

    WHERE o.xtype = 'u'

    AND i.indid < 2

    order by TblRowCount desc