查询每个表的行数

select a.name, b.rowsfrom sysobjects ainner join sysindexes b on a.id = b.idwhere a.type = 'u'and b.indid in (0, 1)order by a.name SELECT o.name AS "Table Name", i.rowcnt AS "Row Count"FROM sysobjects o, sysindexes iWHERE i.id = o.idAND i.indid IN(0,1)AND o.xtype = 'u' --只统计用户表AND o.name <> 'sysdiagrams'ORDER BY i.rowcnt DESC --按行排降序COMPUTE SUM(i.rowcnt), count(o.name); --汇总行数，表数GO