SQL SERVER查询表大小

来源:互联网 发布:ntt数据英特玛 编辑:程序博客网 时间:2024/05/28 15:14
 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
原创粉丝点击