新门店执行

wbv123

–第一步备份
SELECT * into d_HE_SRCORDER_SALE from T_HE_SRCORDER_SALE
select * into d_HE_SRCORDER_m from T_HE_SRCORDER_m
select * into d_HE_SRC2ORD_PRO from T_HE_SRC2ORD_PRO
select * into d_HE_SRCORDER_C from T_HE_SRCORDER_C
select * into d_HE_SRCORDER_d from T_HE_SRCORDER_d
–第二部删除表
drop table t_he_dddw
drop table T_HE_STAMP
drop table T_HE_NATION_AREA
drop table T_HE_PRINTER_RULE
drop table T_HE_SRCORDER_C
drop table T_HE_SRCORDER_d
drop table t_he_srcorder_abnormal
drop table T_HE_SRC2ORD_PRO
drop table T_HE_ECTYPE
drop table T_HE_EXPCMP_HEMS
drop table T_HE_ACCOUNT
drop table T_HE_SRCORDER_SALE
drop table T_HE_SRCORDER_m
drop table t_he_ware_store_set
drop table t_he_ware_store_busi
drop table T_HE_SHOP_O2OBUSI
drop table T_HE_SRCORDER_UPDATE
drop table T_HE_shop
drop table t_he_srcorder_update_his
drop table T_HE_BUSI
drop table T_HE_SRC_UPDATE_RULE
drop table T_HE_EXPCMP_INFO
drop table t_ol_stock_update_his
drop table T_HE_REFUND
drop table t_he_class_up
drop table t_he_class_up_busi
drop table t_he_ware_up
drop table t_he_ware_up_busi
drop table t_he_class_up_task
drop table t_he_ware_up_task