查询所有表的记录数SQLServer
时间：2022-03-10 18:00
SELECT object_name (i.id) TableName,
rows as RowCnt
FROM sysindexes i
INNER JOIN sysObjects o
ON (o.id = i.id AND o.xType = ‘U ‘)
WHERE indid < 2
ORDER BY RowCnt desc,TableName
查询所有表的记录数SQLServer,布布扣,bubuko.com
