use wechatgo
SELECT sysobjects.Name , sysindexes.RowsFROM sysobjects INNER JOIN sysindexes ON sysobjects.id = sysindexes.idWHERE type = ‘U‘ AND sysindexes.IndId < 2
显示数据库中所有表的记录数
原文:http://www.cnblogs.com/zyip/p/3988053.html