ERP数据库删除语句.docx

1、ERP数据库删除语句delete ship_dtlGODBCC CHECKIDENT (ship_dtl, RESEED,0) GOdelete ship_mstGOdelete corder_dtlGODBCC CHECKIDENT (corder_dtl, RESEED,0) GOdelete corder_mstGOdelete ar_invoice_dtl where ar_ivc_no0 GOdelete ar_invoice_mst where ar_ivc_no0GO-delete customer_ship where cust_id not in (default)GOdel

2、ete cashset_dtl GODBCC CHECKIDENT (cashset_dtl, RESEED,0) GOdelete cashset_mstGOdelete material_customerGODBCC CHECKIDENT (material_customer, RESEED,0) GODELETE FROM CUSTOMER_BILLTO GOdelete customer_dtlwhere cust_id not in (default)GOdelete customer_mst where cust_id not in (default)GOdelete custom

3、er_shipwhere cust_id not in (default)GOdelete ap_invoice_dtlwhere vend_id not in (default)GODBCC CHECKIDENT (ap_invoice_dtl, RESEED,0)GOdelete ap_invoice_mstwhere vend_id not in (default)GODBCC CHECKIDENT (ap_invoice_mst, RESEED,0)GOdelete porv_dtl GO DBCC CHECKIDENT (porv_dtl, RESEED,0)GOdelete por

4、v_mst GOdelete material_vendorwhere vend_id not in (default)GODBCC CHECKIDENT (material_vendor, RESEED,0)GOdelete ap_matchwhere VEND_ID not in (default)GODBCC CHECKIDENT (ap_match, RESEED,0)GOdelete porder_dtl GO DBCC CHECKIDENT (porder_dtl, RESEED,0)GOdelete porder_mst GOdelete ap_tax where vend_id

5、 not in (default)GODBCC CHECKIDENT (ap_tax, RESEED,0)GOdelete poir_dtl GODBCC CHECKIDENT (poir_dtl, RESEED,0)GOdelete poir_mst GOdelete vendor_dtlwhere vend_id not in (default)GOdelete vendor_mstwhere vend_id not in (default)GOdelete stock_historyGODBCC CHECKIDENT (stock_history, RESEED,0)GOdelete m

6、aterial_multi_billGOdelete morder_dtl GODBCC CHECKIDENT (morder_dtl, RESEED,0)GOdelete morder_mst GOdelete pick_bill GODBCC CHECKIDENT (pick_bill, RESEED,0)GOdelete pick_dtl GODBCC CHECKIDENT (pick_dtl, RESEED,0)GOdelete pick_mstGOdelete cost_dtl where itemdefaultGODBCC CHECKIDENT (cost_dtl, RESEED,

7、0)GOdelete cost_mst where itemdefaultGODBCC CHECKIDENT (cost_mst, RESEED,0)GOdelete material_lot where itemdefaultGOdelete material_dtl2 where itemdefaultGOdelete material_dtl1 where itemdefaultGOdelete price_list_dtl GODBCC CHECKIDENT (price_list_dtl, RESEED,0)GOdelete price_list_mst GOdelete units

8、_measure where itemdefaultGOdelete material_mst where itemdefaultGOdelete bill_historyGODBCC CHECKIDENT (bill_history, RESEED,0)GOdelete gl_je_dtl GODBCC CHECKIDENT (gl_je_dtl, RESEED,0)GOdelete gl_je_mstGOdelete stock_inventoryGODBCC CHECKIDENT (stock_inventory, RESEED,0)GOdelete material_billGOdel

9、ete DESIGN_BILLGOdelete ORDER_ROUTINGGODBCC CHECKIDENT (ORDER_ROUTING, RESEED,0)GOdelete ROUTINGGODBCC CHECKIDENT (ROUTING, RESEED,0)GOdelete MORV_MSTGOdelete POIR_QI_DTLGOdelete MATERIAL_PROVEGOdelete lot_mstGODBCC CHECKIDENT (lot_mst, RESEED,0)GOtruncate table sys_logGOdelete inva_dtlGODBCC CHECKI

10、DENT (inva_dtl, RESEED,0)GOdelete inva_mstGOdelete journal_batchGODBCC CHECKIDENT (journal_batch, RESEED,0)GOdelete material_fcst_consumeGODBCC CHECKIDENT (material_fcst_consume, RESEED,0)GODELETE FROM STOCK_FROZEN_HISTORYgoDBCC CHECKIDENT (STOCK_FROZEN_HISTORY, RESEED,0)GODELETE FROM ORDER_DTL_MRPD

11、BCC CHECKIDENT (ORDER_DTL_MRP, RESEED,0)GODELETE FROM MORV_DTLDBCC CHECKIDENT (MORV_DTL, RESEED,0)GODELETE FROM SUGGESTION_MRPgoDBCC CHECKIDENT (SUGGESTION_MRP, RESEED,0)GODELETE FROM STOCK_FROZENgoDBCC CHECKIDENT (STOCK_FROZEN, RESEED,0)GODELETE FROM MATERIAL_SAFETYgoDBCC CHECKIDENT (MATERIAL_SAFET

12、Y, RESEED,0)GODELETE FROM STOCK_BINDELETE FROM STOCK_STKDELETE FROM IMTR_DTLDELETE FROM IMTR_MSTDELETE FROM MANUFACTURE_CNFG WHERE PLANT00000DELETE FROM LOT_CNFG WHERE PLANT00000DELETE FROM PLANTS WHERE PLANT00000DELETE FROM PURCHASE_CNFG WHERE PURCHASE00000DELETE FROM AP_CNFG WHERE PURCHASE00000DEL

13、ETE FROM AP_AGE WHERE PURCHASE00000DELETE FROM PURCHASE_PLANT WHERE PURCHASE00000DELETE FROM PURCHASE_ORG WHERE PURCHASE00000 GOdelete from ORDER_ROUTING_MRPGODBCC CHECKIDENT (ORDER_ROUTING_MRP, RESEED,0)GOSELECT *FROM TICKET_MAXIMUMGOUPDATE TICKET_MAXIMUM SET MAXIMUM=0GODELETE FROM STOCK_WIP_BALANC

14、EDELETE FROM STOCK_BALANCEDELETE FROM STOCK_WIP_JOURNALDELETE FROM STOCK_JOURNALGODELETE FROM MORDER_SHORTGODELETE FROM AP_APPLYGODELETE FROM SERIALNOGODELETE FROM HEATNOGODELETE FROM MOMTCHECK_DTLGODELETE FROM LEVEL_PICK_BILLGODELETE FROM CORDER_STAT_LOGGODELETE FROM LABOR_FEEDBACKGODBCC CHECKIDENT

15、 (LABOR_FEEDBACK, RESEED,0)GODELETE FROM ROUTING_OPERATIONSGODBCC CHECKIDENT (ROUTING_OPERATIONS, RESEED,0)GODELETE FROM PICK_BILL_MRPGODELETE FROM GL_TOTAL_AMTGODELETE FROM MOMTCHECK_MSTGODELETE FROM GL_BALANCEGODELETE FROM ORG_MEMBER WHERE COMPANY00000GODBCC CHECKIDENT (ORG_MEMBER, RESEED,0)GODELE

16、TE FROM ORG_DTL WHERE COMPANY00000GODBCC CHECKIDENT (ORG_DTL, RESEED,0)GODELETE FROM ORG_MST WHERE COMPANY00000GODELETE FROM GL_ACT_MEMBER WHERE COMPANY00000GODBCC CHECKIDENT (GL_ACT_MEMBER, RESEED,0)GODELETE FROM GL_ACT_DTL WHERE COMPANY00000GODBCC CHECKIDENT (GL_ACT_DTL, RESEED,0)GODELETE FROM GL_

17、ACT_MST WHERE COMPANY00000GOselect *from usersdelete from users where user_id not in (admin,zhb)SELECT *FROM EMPLOYEE_MSTSELECT *FROM VENDOR_DTLdelete from EMPLOYEE_MST where EMPLOYEE_ID not in (admin,zhb,DEFAULT,DEFU1)select *from REASON_ACCTdelete from REASON_ACCTgoDBCC CHECKIDENT (REASON_ACCT, RE

18、SEED,0)GOselect *from REASON_DUEselect *from REASON_MSTdelete from REASON_MST where reason_id not in (999)goSELECT *FROM STD_OPERATIONDELETE FROM OPERATION_MSTDELETE FROM WORKCENTER_MST WHERE WC_NO NOT IN(1,2,3,4,5,6,7,8,9,10,DEFAULT)DELETE FROM STD_OPERATION WHERE OP_IDDEFAULTSELECT *FROM EMPLOYEE_

19、MSTSELECT *FROM EUSE WTEST6GODBCC SHRINKDATABASE(NWTEST6 )GOSELECT *FROM ROUTINGINSERT INTO ROUTING (ITEM, PLANT, ROUT_ID, OP_SEQN, STD_OP, OP_DESC1, OP_DESC2, WC_NO, SETUP_TIME, RUN_TIME, MOVE_TIME, OVERLAP_UNITS, BAS_QTY, MILESTONE_OP, CRITICAL_OP, YIELD, INV_VALUE, VEND_ID, SUB, SUB_PRICE, SUB_LT

20、, TEXT_NO, QUEUE_TIME, WAIT_TIME, SETUP_CREW, RUN_CREW, MACHS_OP, IN_EFFECT, OUT_EFFECT, WIP_ITEM, MOVE_NEXT_OP, AUTO_LAB_REP)SELECT ITEM, PLANT, ROUT_ID, OP_SEQN, STD_OP, OP_DESC1, OP_DESC2, WC_NO, SETUP_TIME, RUN_TIME, MOVE_TIME, OVERLAP_UNITS, BAS_QTY, MILESTONE_OP, CRITICAL_OP, YIELD, INV_VALUE, VEND_ID, SUB, SUB_PRICE, SUB_LT, TEXT_NO, QUEUE_TIME, WAIT_TIME, SETUP_CREW, RUN_CREW, MACHS_OP, IN_EFFECT, OUT_EFFECT, WIP_ITEM, MOVE_NEXT_OP, AUTO_LAB_REPFROM QHTEST.ROUTINGwhere item in (000001)