脚本
1
SELECT o.name
AS "
Table Name",o.info
as ColCount, i.rowcnt
AS "
RowCount",o.Crdate
2 FROM sysobjects o, sysindexes i
3 WHERE i.id = o.id
4 AND i.indid IN( 0, 1)
5 AND o.xtype = ' u ' -- 只统计用户表
6 AND o.name <> ' sysdiagrams '
7 ORDER BY i.rowcnt DESC -- 按行排降序
8
2 FROM sysobjects o, sysindexes i
3 WHERE i.id = o.id
4 AND i.indid IN( 0, 1)
5 AND o.xtype = ' u ' -- 只统计用户表
6 AND o.name <> ' sysdiagrams '
7 ORDER BY i.rowcnt DESC -- 按行排降序
8
9 --COMPUTE SUM(i.rowcnt),count(o.name);--汇总行数,表数