sql server 计算表记录数、当前自增值和占用空间 无 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 = i
sql server 计算表记录数、当前自增值和占用空间
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