简单易用，适用各个版本 2000-2008实测可用。
|
1 2 3 4 |
select object_name(id) tablename,8*reserved/1024 reserved1 ,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 |
© 2017, ITJOY.NET. 版权所有. 如未注明，均为原创，转载请注明出处。