查询sql数据表的数据量

脚本

SELECT a.name, b.rows
FROM sysobjects AS a INNER JOIN sysindexes AS b ON a.id = b.id
WHERE (a.type = 'u') AND (b.indid IN (0, 1))
ORDER BY a.name,b.rows DESC

 

posted @ 2022-05-19 15:27  世人皆萌  阅读(562)  评论(0编辑  收藏  举报