数据库表大小排序

if object_id(N'tempdb.db.#t') is not null
drop table #t
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 [rows]