赛博保安员

2015-02-05 14:47

1

2

3

4

5

6

7

select sobj.name,spar.rows

FROM sys.objects sobj

INNER JOIN sys.partitions spar

ON sobj.object_id = spar.object_id

WHERE sobj.type IN ('U','V')

AND spar.index_id IN (0,1)

ORDER BY spar.rows desc

相关sys表的说明参考如下的网页。

select * from sys.dm_server_registry

查询某库所有表的rows &查看当前sql的注册信息