The following query finds all tables in a schema, ordered by row count:
SELECT
sysobjects.*
, sysindexes.Rows
FROM
sysobjects
INNER JOIN sysindexes
ON sysobjects.id = sysindexes.id
WHERE
type = 'U'
AND sysindexes.IndId < 2
ORDER BY sysindexes.Rows desc