--按表名排序
SELECT o.[name], [rows] FROM sysobjects o JOIN sysindexes i ON o.id = i.id WHERE i.indid < 2 AND o.type = 'U' ORDER BY o.[name]

--按行数排序
SELECT o.[name], [rows] FROM sysobjects o JOIN sysindexes i ON o.id = i.id WHERE i.indid < 2 AND o.type = 'U' ORDER BY [rows] desc