Shulou(Shulou.com)06/01 Report--

Click (here) to collapse or open

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. Xtypee 'and a.name like' TRP%'

Group by a.name

) rr

On a.name=rr.tbname

Where a.typewriters' and a.name like 'TRP%' and rr.row_num > 1000000

Order by rr.row_num desc

Go

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.