SELECT A.NAME AS 表名,B.ROWCNT AS 记录数

FROM SYSOBJECTS A

    JOIN SYSINDEXES B

       ON A.ID=B.ID AND A.XTYPE='U'

           AND B.INDID<2

 

http://blog.csdn.net/htl258/archive/2010/04/18/5500175.aspx


本文转载:CSDN博客