执行下面脚本,可以看表占用空间排序,方便清理数据。 SELECT A.NAME ,B.ROWS FROM sysobjects A JOIN sysindexes B ON A.id = B.id WHERE A.xtype = ‘U’ AND B.indid IN(0,1) ORDER BY B.ROWS DESC