【sqlserver】查询 表的大小

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

请使用浏览器的分享功能分享到微信等