查询数据库所有表数据量

select b.name,a.row_count from sys.dm_db_partition_stats a,
sys.objects b
where a.object_id=b.object_id 
and a.index_id<=1
and b.type='U'  ORDER BY  row_count