mayb

好记性不如烂笔头。
当前位置： 首页 > SqlServer

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