数据库计算每个表所占空间和记录数

sql server 1 USE database_20160215 2 GO 3 4 SELECT 5 TableName = obj.name, 6 TotalRows = prt.rows, 7 [SpaceUsed(KB)] = SUM(alloc.used_pages)*8 8 FROM sys.objects obj 9 JOIN sys.indexes idx on obj.object_id = idx.object_id 10 JOIN sys.partitions prt on obj.object_id = prt.object_i