SQL Server 计算表记录数和占用空间
- 作者: 向進之
- 来源: 51数据库
- 2022-08-17
USE ADVENTUREWORKS GO -- Count All Rows and Size of Table by SQLServerCurry.com SELECT TableName = obj.name, TotalRows = prt.rows, [SpaceUsed(KB)] = SUM(alloc.used_pages)*8 FROM sys.objects obj JOIN sys.indexes idx on obj.object_id = idx.object_id JOIN sys.partitions prt on obj.object_id = prt.object_id JOIN sys.allocation_units alloc on alloc.container_id = prt.partition_id WHERE obj.type = 'U' AND idx.index_id IN (0, 1) GROUP BY obj.name, prt.rows ORDER BY TableName
推荐阅读
