SELECT 
t.NAME AS TableName,
s.NAME AS SchemaName,
p.rows AS RowCounts,
SUM(a.total_pages) * 8 AS TotalSizeKB 

FROM

sys.tables t 

INNER JOIN

sys.indexes i ON t.OBJECT_ID = i.object_id 

INNER JOIN

sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id 

INNER JOIN

sys.allocation_units a ON p.partition_id = a.container_id 

LEFT OUTER JOIN

sys.schemas s ON t.schema_id = s.schema_id 

GROUP BY

t.Name, s.Name, p.Rows 

ORDER BY

TotalSizeKB DESC;

公共网盘模板含以下基础功能
创建目录.png
创建文件.png
目录层级.png
目录压缩.png
目录重命名.png
网盘物理目录.png
文件或目录删除.png
文件上传.png
文件下载.png
文件重命名.png

需要源码的微信联系joyokim,备注公共网盘。