SQL如何获取指定数据库所有表的物理大小？

sql如何获取指定所有表的物理大小？

create table tmp
(
    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 name
drop table tmp ;