标题：查询SQL Server数据库表占用空间的SQL语句

 
create table #t
(name varchar(255),
rows bigint,
reserved varchar(20),
data varchar(20),
index_size varchar(20),
unused varchar(20))

exec sp_MSforeachtable "insert into #t exec sp_spaceused '?'"
select *
from #t
order  by data desc,index_size desc
--drop table #t