查询某库所有表的rows &查看当前sql的注册信息
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表的说明参考如下的网页。
http://tech.chinaunix.net/a2009/0105/262/000000262200.shtml
select * from sys.dm_server_registry