仓库在没有发生业务的情况下想要删除?

【概述】

确认仓库没有业务发生情况下,删除脚本如下： 备份库位分类表： select * into LocationGroupbak_0322 from T_IN_LocationGroup where FWarehouseID in (select fid from t_db_warehouse where fnumber in ('仓库编码','仓库编码')) 删除库位分类： delete from T_IN_LocationGroup where FWarehouseID in (select fid from t_db_warehouse where fnumber in ('仓库编码','仓库编码')) 备份仓库收款组织表： select * into soaccreditwhbak_0322 from t_db_soaccreditwh where FWarehouseID in (select fid from t_db_warehouse where fnumber in (