统计SQL Server所有表记录数 

SELECT  SCHEMA_NAME(t.schema_id) AS [schema] ,t.name AS tableName ,i.rows AS [rowCount]
FROM    sys.tables AS t ,
        sysindexes AS i
WHERE   t.object_id = i.id  AND i.indid <= 1 AND i.rows>0 order by t.name asc

 

posted @ 2018-05-15 10:27  云天  阅读(235)  评论(0)  编辑  收藏  举报