摘要： --查询数据库中所有表大小及数据量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 SYSINDEXESORDER BY reserved DESC 阅读全文