[MSSQL]查看数据库中所有表的数据行数-日志-光明领域，提供各类软件下载，各类日志

日志分类

文章日志

[MSSQL]查看数据库中所有表的数据行数

日志类别：数据库

2017-01-10 11:59

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

1 0