ERP数据库删除语句.docx
《ERP数据库删除语句.docx》由会员分享，可在线阅读，更多相关《ERP数据库删除语句.docx（14页珍藏版）》请在冰点文库上搜索。
ERP数据库删除语句
deleteship_dtl
GO
DBCCCHECKIDENT（'ship_dtl',RESEED,0）
GO
deleteship_mst
GO
deletecorder_dtl
GO
DBCCCHECKIDENT（'corder_dtl',RESEED,0）
GO
deletecorder_mst
GO
deletear_invoice_dtlwherear_ivc_no<>0
GO
deletear_invoice_mstwherear_ivc_no<>0
GO
--Ö´ÐÐÍê±Ï
deletecustomer_shipwherecust_idnotin（'default'）
GO
deletecashset_dtl
GO
DBCCCHECKIDENT（'cashset_dtl',RESEED,0）
GO
deletecashset_mst
GO
deletematerial_customer
GO
DBCCCHECKIDENT（'material_customer',RESEED,0）
GO
DELETEFROMCUSTOMER_BILLTO
GO
deletecustomer_dtl
wherecust_idnotin（'default'）
GO
deletecustomer_mst
wherecust_idnotin（'default'）
GO
deletecustomer_ship
wherecust_idnotin（'default'）
GO
deleteap_invoice_dtl
wherevend_idnotin（'default'）
GO
DBCCCHECKIDENT（'ap_invoice_dtl',RESEED,0）
GO
deleteap_invoice_mst
wherevend_idnotin（'default'）
GO
DBCCCHECKIDENT（'ap_invoice_mst',RESEED,0）
GO
deleteporv_dtl
GO
DBCCCHECKIDENT（'porv_dtl',RESEED,0）
GO
deleteporv_mst
GO
deletematerial_vendor
wherevend_idnotin（'default'）
GO
DBCCCHECKIDENT（'material_vendor',RESEED,0）
GO
deleteap_match
whereVEND_IDnotin（'default'）
GO
DBCCCHECKIDENT（'ap_match',RESEED,0）
GO
deleteporder_dtl
GO
DBCCCHECKIDENT（'porder_dtl',RESEED,0）
GO
deleteporder_mst
GO
deleteap_tax
wherevend_idnotin（'default'）
GO
DBCCCHECKIDENT（'ap_tax',RESEED,0）
GO
deletepoir_dtl
GO
DBCCCHECKIDENT（'poir_dtl',RESEED,0）
GO
deletepoir_mst
GO
¡¡¡¡
deletevendor_dtl
wherevend_idnotin（'default'）
GO
deletevendor_mst
wherevend_idnotin（'default'）
GO
¡¡¡¡
deletestock_history
GO
DBCCCHECKIDENT（'stock_history',RESEED,0）
GO
deletematerial_multi_bill
GO
deletemorder_dtl
GO
DBCCCHECKIDENT（'morder_dtl',RESEED,0）
GO
deletemorder_mst
GO
deletepick_bill
GO
DBCCCHECKIDENT（'pick_bill',RESEED,0）
GO
deletepick_dtl
GO
DBCCCHECKIDENT（'pick_dtl',RESEED,0）
GO
deletepick_mst
GO
deletecost_dtlwhereitem<>'default'
GO
DBCCCHECKIDENT（'cost_dtl',RESEED,0）
GO
deletecost_mstwhereitem<>'default'
GO
DBCCCHECKIDENT（'cost_mst',RESEED,0）
GO
¡¡¡¡
deletematerial_lotwhereitem<>'default'
GO
¡¡¡¡
deletematerial_dtl2whereitem<>'default'
GO
¡¡¡¡
deletematerial_dtl1whereitem<>'default'
GO
deleteprice_list_dtl
GO
DBCCCHECKIDENT（'price_list_dtl',RESEED,0）
GO
deleteprice_list_mst
GO
deleteunits_measurewhereitem<>'default'
GO
deletematerial_mstwhereitem<>'default'
GO
deletebill_history
GO
DBCCCHECKIDENT（'bill_history',RESEED,0）
GO
deletegl_je_dtl
GO
DBCCCHECKIDENT（'gl_je_dtl',RESEED,0）
GO
deletegl_je_mst
GO
deletestock_inventory
GO
DBCCCHECKIDENT（'stock_inventory',RESEED,0）
GO¡¡¡¡
deletematerial_bill
GO
deleteDESIGN_BILL
GO
deleteORDER_ROUTING
GO
DBCCCHECKIDENT（'ORDER_ROUTING',RESEED,0）
GO¡¡
deleteROUTING
GO
DBCCCHECKIDENT（'ROUTING',RESEED,0）
GO¡¡
deleteMORV_MST
GO
deletePOIR_QI_DTL
GO
deleteMATERIAL_PROVE
GO
deletelot_mst
GO
DBCCCHECKIDENT（'lot_mst',RESEED,0）
GO
truncatetablesys_log
GO
deleteinva_dtl
GO
DBCCCHECKIDENT（'inva_dtl',RESEED,0）
GO
deleteinva_mst
GO
deletejournal_batch
GO
DBCCCHECKIDENT（'journal_batch',RESEED,0）
GO
deletematerial_fcst_consume
GO
DBCCCHECKIDENT（'material_fcst_consume',RESEED,0）
GO
DELETEFROMSTOCK_FROZEN_HISTORY
go
DBCCCHECKIDENT（'STOCK_FROZEN_HISTORY',RESEED,0）
GO
DELETEFROMORDER_DTL_MRP
DBCCCHECKIDENT（'ORDER_DTL_MRP',RESEED,0）
GO
DELETEFROMMORV_DTL
DBCCCHECKIDENT（'MORV_DTL',RESEED,0）
GO
DELETEFROMSUGGESTION_MRP
go
DBCCCHECKIDENT（'SUGGESTION_MRP',RESEED,0）
GO
DELETEFROMSTOCK_FROZEN
go
DBCCCHECKIDENT（'STOCK_FROZEN',RESEED,0）
GO
DELETEFROMMATERIAL_SAFETY
go
DBCCCHECKIDENT（'MATERIAL_SAFETY',RESEED,0）
GO
DELETEFROMSTOCK_BIN
DELETEFROMSTOCK_STK
DELETEFROMIMTR_DTL
DELETEFROMIMTR_MST
DELETEFROMMANUFACTURE_CNFGWHEREPLANT<>'00000'
DELETEFROMLOT_CNFGWHEREPLANT<>'00000'
DELETEFROMPLANTSWHEREPLANT<>'00000'
DELETEFROMPURCHASE_CNFGWHEREPURCHASE<>'00000'
DELETEFROMAP_CNFGWHEREPURCHASE<>'00000'
DELETEFROMAP_AGEWHEREPURCHASE<>'00000'
DELETEFROMPURCHASE_PLANTWHEREPURCHASE<>'00000'
DELETEFROMPURCHASE_ORGWHEREPURCHASE<>'00000'
GO
deletefromORDER_ROUTING_MRP
GO
DBCCCHECKIDENT（'ORDER_ROUTING_MRP',RESEED,0）
GO
SELECT*
FROMTICKET_MAXIMUM
GO
UPDATETICKET_MAXIMUMSETMAXIMUM=0
GO
DELETEFROMSTOCK_WIP_BALANCE
DELETEFROMSTOCK_BALANCE
DELETEFROMSTOCK_WIP_JOURNAL
DELETEFROMSTOCK_JOURNAL
GO
DELETEFROMMORDER_SHORT
GO
DELETEFROMAP_APPLY
GO
DELETEFROMSERIALNO
GO
DELETEFROMHEATNO
GO
DELETEFROMMOMTCHECK_DTL
GO
DELETEFROMLEVEL_PICK_BILL
GO
DELETEFROMCORDER_STAT_LOG
GO
DELETEFROMLABOR_FEEDBACK
GO
DBCCCHECKIDENT（'LABOR_FEEDBACK',RESEED,0）
GO
DELETEFROMROUTING_OPERATIONS
GO
DBCCCHECKIDENT（'ROUTING_OPERATIONS',RESEED,0）
GO
DELETEFROMPICK_BILL_MRP
GO
DELETEFROMGL_TOTAL_AMT
GO
DELETEFROMMOMTCHECK_MST
GO
DELETEFROMGL_BALANCE
GO
DELETEFROMORG_MEMBERWHERECOMPANY<>'00000'
GO
DBCCCHECKIDENT（'ORG_MEMBER',RESEED,0）
GO
DELETEFROMORG_DTLWHERECOMPANY<>'00000'
GO
DBCCCHECKIDENT（'ORG_DTL',RESEED,0）
GO
DELETEFROMORG_MSTWHERECOMPANY<>'00000'
GO
DELETEFROMGL_ACT_MEMBERWHERECOMPANY<>'00000'
GO
DBCCCHECKIDENT（'GL_ACT_MEMBER',RESEED,0）
GO
DELETEFROMGL_ACT_DTLWHERECOMPANY<>'00000'
GO
DBCCCHECKIDENT（'GL_ACT_DTL',RESEED,0）
GO
DELETEFROMGL_ACT_MSTWHERECOMPANY<>'00000'
GO
select*
fromusers
deletefromuserswhereuser_idnotin（'admin','zhb'）
SELECT*
FROMEMPLOYEE_MST
SELECT*
FROMVENDOR_DTL
deletefromEMPLOYEE_MSTwhereEMPLOYEE_IDnotin（'admin','zhb','DEFAULT','DEFU1'）
select*
fromREASON_ACCT
deletefromREASON_ACCT
go
DBCCCHECKIDENT（'REASON_ACCT',RESEED,0）
GO
select*
fromREASON_DUE
select*
fromREASON_MST
deletefromREASON_MSTwherereason_idnotin（'999'）
go
SELECT*
FROMSTD_OPERATION
DELETEFROMOPERATION_MST
DELETEFROMWORKCENTER_MSTWHEREWC_NONOTIN（'1','2','3','4','5','6','7','8','9','10','DEFAULT'）
DELETEFROMSTD_OPERATIONWHEREOP_ID<>'DEFAULT'
SELECT*
FROMEMPLOYEE_MST
SELECT*
FROME
USE[WTEST6]
GO
DBCCSHRINKDATABASE（N'WTEST6'）
GO
SELECT*
FROMROUTING
INSERTINTOROUTING（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_REP）
SELECTITEM,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_REP
FROMQHTEST..ROUTING
whereitemin（'000001'）
升级会员 