27,579
社区成员
发帖
与我相关
我的任务
分享
select 表名=a.name,
行计数=b.rows
from sys.tables a
join (select object_id,
rows=sum(rows)
from sys.partitions
group by object_id) b on a.object_id=b.object_id
where a.name=N'表名'
--自己替换表名
EXEC sp_spaceused 'tableName'
select a.name,b.rows
from sysobjects a inner join sysindexes b on a.id = b.id
where xtype='U' and b.indid in (0,1)
order by b.rows desc
选择你的数据库,执行这个脚本,就是。