统计数据库各表数据量

SQLServer

--查询数据表数据行数
SELECT
    A.NAME ,
    B.ROWS 
FROM
    SYSOBJECTS A
    JOIN SYSINDEXES B ON A.ID = B.ID 
WHERE
    A.XTYPE = 'U' 
    AND B.INDID IN ( 0, 1 ) 
ORDER BY
    B.ROWS DESC;

--查询数据表存储空间使用情况
SELECT
    OBJECT_NAME( ID ) TABLENAME,
    8 * RESERVED / 1024 RESERVED,
    RTRIM( 8 * DPAGES ) AS 'USED(KB)',
    8 * ( RESERVED - DPAGES ) / 1024 UNUSED,
    8 * DPAGES / 1024 - ROWS / 1024 * MINLEN / 1024 FREE 
FROM
    SYSINDEXES 
WHERE
    INDID = 1 
ORDER BY
    RESERVED DESC;