D-Recovery For SQLServer Introduction...
这个功能,就是把这个库中的所有表的每张表的记录数量罗列出来,并且按照记录数量从达到小排列。
![D-Recovery For SQLServer 查询某个数据库所有表记录数量](images/连接数据库10.png)
![D-Recovery For SQLServer 查询某个数据库所有表记录数量显示结果](images/连接数据库08.png)
查询SQL脚本如下:
SELECT '['+(select name FROM [dbo].[sysusers] where uid =o.uid)+'].['+object_name (i.id)+']' TableName,
rows as RowCnt
FROM sysindexes i
INNER JOIN sysobjects o
ON (o.id = i.id AND o.xType = 'U ')
WHERE indid < 2
ORDER BY RowCnt desc