SQL 获取各表记录数的最快方法

select distinct o.name,i.rows from sysobjects o,sysindexes  i where o.id=i.id and o.Xtype= 'U' and i.indid <2 Order By i.rows Desc

原文地址:https://www.cnblogs.com/Cavalry/p/3238497.html