--查询当前表的数据量计数 select max(a.rowcnt) 计数 from sysindexes a join sys.objects b on b.object_id=a.id where b.[name]='kucun'--查询当前数据库的数据量计数,按表分组 use --数据库 select max(a.rowcnt) 计数,b.[name] 表名 from sysindexes a join sys.objects b on b.object_id=a.id where b.type='U' group by b.[name] having max(a.rowcnt) >0 order by 1 desc
select max(a.rowcnt) 计数,b.[name] 表名 from sysindexes a join sys.objects b on b.object_id=a.id where b.type='U' group by b.[name] having max(a.rowcnt) >0
select top 1 b.name from sysindexes a join sysobjects b on b.id=a.id where b.xtype='u' group by b.name order by max(a.rowcnt) desc
select max(a.rowcnt) 计数
from sysindexes a
join sys.objects b on b.object_id=a.id
where b.[name]='kucun'--查询当前数据库的数据量计数,按表分组
use --数据库
select max(a.rowcnt) 计数,b.[name] 表名
from sysindexes a
join sys.objects b on b.object_id=a.id
where b.type='U'
group by b.[name]
having max(a.rowcnt) >0
order by 1 desc
from sysindexes a
join sys.objects b on b.object_id=a.id
where b.type='U'
group by b.[name]
having max(a.rowcnt) >0
from sysindexes a
join sysobjects b on b.id=a.id
where b.xtype='u'
group by b.name
order by max(a.rowcnt) desc