SELECT a.name, b.rowsFROM sysobjects AS a INNER JOIN sysindexes AS b ON a.id = b.idWHERE (a.type = ‘u‘) AND (b.indid IN (0, 1))ORDER BY b.rows DESC
查询数据库表大小sql
原文：http://www.cnblogs.com/ziye/p/5197832.html
