SQL server 查询库中每表记录数,字节数和总数

 

SELECT * FROM sys.all_objects

查询系统表的内容

 

 

 

USE cjml_basecenter;
GO
SELECT o.name,
       SUM(p.reserved_page_count) * 8 table_size_kb,
       SUM(p.reserved_page_count) * 8 / 1024 table_size_mb,
       SUM(   CASE
                  WHEN (p.index_id < 2) THEN
                      row_count
                  ELSE
                      0
              END
          ) AS rowcounts
FROM sys.dm_db_partition_stats p
    INNER JOIN sys.objects o
        ON o.object_id = p.object_id
WHERE o.type = 'U' and o.name not like 'sys%'
GROUP BY o.name 
WITH ROLLUP
ORDER BY  1