点击(此处)折叠或打开

select a.name as tabname
,h.name as idname
,rr.row_num as rownum
from sys.objects as a
right join sys.indexes as h
on a.object_id=h.object_id
join ( select a.name as tbname,max(b.rows) as row_num
from sysobjects a ,sysindexes b
where a.id=b.id and a.xtype='u' and a.name like 'TRP%'
group by a.name
) rr
on a.name=rr.tbname
where a.type<>'s' and a.name like 'TRP%' and rr.row_num>1000000
order by rr.row_num desc
go