MSSQL 统计整个数据库所有表数据记录数
SELECT b.name AS tablename, a.rowcnt AS datacount FROM sysindexes a, sysobjects b
WHERE a.id = b.id AND a.indid < 2 AND objectproperty(b.id, ‘IsMSShipped‘) = 0 ORDER BY datacount DESC
温馨提示: 本文由Jm博客推荐，转载请保留链接: https://www.jmwww.net/SQL/22067.html
