清除数据库无用的记录

## 查询各个表的记录数

select a.name, b.rows
from sysobjects a
inner join sysindexes b on a.id = b.id
where a.type = 'u'
and b.indid in (0, 1)
order by b.rows desc

## 截断一些无用的表,减小数据库体积大小

truncate table AutoRunnerRecords
truncate table informations
truncate table applicationlogs

原文地址:https://www.cnblogs.com/zinan/p/10904828.html