SQL 自动清除7天前数据前收缩数据库

原创于 2023-08-12 17:33:39 发布 · 902 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#sql #性能优化

本文介绍了如何使用SQL脚本delete-Ecustom-xml-midtable.sql，针对七天前的数据库中间表数据进行删除，并执行GODBCCSHRINKDATABASE命令收缩ECustomXML数据库，以维护数据库效率。

作用：
删除七天前数据库中间表的资料，并收缩数据库

delete-Ecustom-xml-midtable.sql
delete Mid_bom where datediff(day,dty,getdate())>=7
delete Mid_cus where datediff(day,dty,getdate())>=7
delete Mid_exp where datediff(day,dty,getdate())>=7
delete Mid_inv where datediff(day,dty,getdate())>=7
delete Mid_itm where datediff(day,dty,getdate())>=7
delete Mid_opi where datediff(day,dty,getdate())>=7
delete Mid_opo where datediff(day,dty,getdate())>=7
delete Mid_ord where datediff(day,dty,getdate())>=7
delete Mid_pur where datediff(day,dty,getdate())>=7
delete Mid_rec where datediff(day,dty,getdate())>=7
delete Mid_stk where datediff(day,dty,getdate())>=7
delete Mid_vdr where datediff(day,dty,getdate())>=7
delete Mid_vla where datediff(day,dty,getdate())>=7
delete Mid_wip where datediff(day,dty,getdate())>=7
GO
DBCC SHRINKDATABASE(ECustomXML)