MS Sql中取每个表的大小，行数
1
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,
2rows,* from sysindexes
3where indid=1
4order by rows desc
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,2
rows,* from sysindexes 3
where indid=1 4
order by rows desc
浙公网安备 33010602011771号