加载中…sql server使用sql语句查看表空间大小
(2013-11-12 09:00:57)
标签：
it |
分类： 程序乐土-数据库 |
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
rows from sysindexes
where indid=1
order by reserved desc
喜欢
0
赠金笔
前一篇：adb资料