SQL Server 计算表记录数和占用空间
程序员文章站
2022-04-28 11:45:41
...
无详细内容 无 USE ADVENTUREWORKSGO-- Count All Rows and Size of Table by SQLServerCurry.comSELECTTableName = obj.name,TotalRows = prt.rows,[SpaceUsed(KB)] = SUM(alloc.used_pages)*8FROM sys.objects objJOIN sys.indexes idx on obj.object_id =
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