select t.name ,s.row_count from sys.tables t

join sys.dm_db_partition_stats s

ON t.object_id = s.object_id

and t.type_desc = 'USER_TABLE'

and t.name not like '%dss%'

and s.index_id = 1

order by row_count desc

select  a.name as '表名',b.rows as '表数据行数'

from sysobjects a inner join sysindexes b

on a.id = b.id

where   a.type = 'u'

and b.indid in (0,1)

--and a.name not like 't%'

order by b.rows desc