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