-
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
|