SQL查询某数据库各表占用磁盘空间

引用blog http://www.cnblogs.com/hanguoji/archive/2009/06/09/1499880.html

1select object_name(id) tablename,8*reserved/1024 as 空间,rtrim(8*dpages/1024)+'Mb' as 使用空间used,8*(reserved-dpages)/1024 unused,8*dpages/1024-rows/1024*minlen/1024 free,
2rows from sysindexes 
3where indid=1 
4order by reserved desc

--查单个表所占用的空间
EXEC sp_spaceused 'MoneyFlow'
GO