sql数据库怎么统计数据库中每张表的大小

create table tmp(
  name varchar(50),
  rows int,
  reserved varchar(50), 
  data varchar(50),
  index_size varchar(50),
  unused varchar(50)
);
 
insert into tmp (
  name, rows, reserved, data, index_size, unused
) exec sp_MSforeachtable @command1="sp_spaceused '?'";

select * from tmp where name <> 'tmp' order by data desc  ;

drop table tmp ;
 

select 表名=a.name, 记录数=b.rows
from sysobjects a, sysindexes b
where a.name=b.name and a.type='u'
order by b.rows desc