The number of records in the SQL server computing table, the current auto-increment value, and the occupied space are not SELECTTableNameobj. name, TotalRowsprt. rows, Identity_CurrentIDENT_CURRENT (obj. name), [SpaceUsed (KB)] SUM (alloc. used_pages) * 8FROMsys. objectsobjJOINsys. indexesidxonobj. object_idi
No SELECTTableName = obj. name, TotalRows = prt. rows, Identity_Current = IDENT_CURRENT (obj. name), [SpaceUsed (KB)] = SUM (alloc. used_pages) * 8 FROM sys. objects objJOIN sys. indexes idx on obj. object_id = I
SQL Server calculates the number of table records, current auto-increment value, and occupied space
<无>
SELECTTableName = obj.name,TotalRows = prt.rows,Identity_Current=IDENT_CURRENT(obj.name),[SpaceUsed(KB)] = SUM(alloc.used_pages)*8FROM sys.objects objJOIN sys.indexes idx on obj.object_id = idx.object_idJOIN sys.partitions prt on obj.object_id = prt.object_idJOIN sys.allocation_units alloc on alloc.container_id = prt.partition_idWHEREobj.type = 'U' AND idx.index_id IN (0, 1)GROUP BY obj.name, prt.rowsORDER BY TableName