查看 sql server 所有表的记录数

96
Spooking
2020-07-11 16:49:40 字数 33 阅读 80

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 b.rows DESC

编程&开发
备案号:陕ICP备16003225号-1