查看SQL Server数据库表 行数,数据大小,占用空间

--查看数据库表 行数,数据大小,占用空间
DECLARE @tmp table (
    name varchar(50),
    rowscount int,
    reserved varchar(50),  
    data varchar(50),
    index_size varchar(50),
    unused varchar(50)
);
  
insert @tmp(name, rowscount, reserved, data, index_size, unused) 
exec sp_MSforeachtable @command1="sp_spaceused '?'";
select * from @tmp where name <> 'tmp' order by rowscount desc