无详细内容 无 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
已抢186982个
抢已抢67462个
抢已抢353655个
抢已抢668164个
抢已抢123572个
抢已抢25455个
抢