按表的记录数大小排序-CSDN博客

网站介绍:文章浏览阅读589次。SELECT 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 rows desc CallD