테이블 건수

SELECT o.name

     , i.rows

FROM   sysindexes i

           INNER JOIN sysobjects o ON i.id = o.id

WHERE  i.indid < 2

   AND o.xtype = 'U'

ORDER BY

       i.rows DESC

출처: http://akbory.tistory.com/2 [惡보리]