SELECT OBJECT_NAME(ii.id) TableName ,rows
FROM sysindexes ii
INNER JOIN sysobjects oo
ON ( oo.id = ii.id
AND oo.xtype = 'U ')
WHERE ii.indid < 2
ORDER BY rows desc ;
SQLserver查询当前数据库所有表的行数
最新推荐文章于 2024-08-26 10:40:19 发布
SELECT OBJECT_NAME(ii.id) TableName ,rows
FROM sysindexes ii
INNER JOIN sysobjects oo
ON ( oo.id = ii.id
AND oo.xtype = 'U ')
WHERE ii.indid < 2
ORDER BY rows desc ;