1: SELECT a.name, b.rows
2: FROM sysobjects AS a INNER JOIN
3: sysindexes AS b ON a.id = b.id
4: WHERE (a.type = 'u') AND (b.indid IN (0, 1))
5: ORDER BY b.rows DESC
本文转自 sun8134 博客园博客,原文链接: http://www.cnblogs.com/sun8134/archive/2012/09/29/2708043.html ,如需转载请自行联系原作者