刚刚需要用到的,记录一下,SQL05以上管用,2000没试过。。。
select
b.
[
name
]
表名,
max
(a.rowcnt) 记录数
from sysindexes a
join sys.objects b on b. object_id = a.id
where b.type = ' U '
group by b. [ name ]
from sysindexes a
join sys.objects b on b. object_id = a.id
where b.type = ' U '
group by b. [ name ]