如何查当前的数据库各个表所占的行数

SELECT TOP 100 Percent
   sysobjects.name,
   sysindexes.rows
 FROM sysindexes with(nolock)
   JOIN sysobjects with(nolock)
    ON sysindexes.id = sysobjects.id AND sysobjects.xtype = 'u'
WHERE sysindexes.indid in(0, 1)
order by rows desc

转载于:https://blog.51cto.com/roboboy/99555