SELECT
o.name
AS
"
Table
Name", i.rowcnt
AS
"Row
Count
"
FROM
sysobjects o, sysindexes i
WHERE
i.id
=
o.id
AND
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