ERP数据库删除语句Word格式文档下载.docx

ERP数据库删除语句Word格式文档下载.docx

《ERP数据库删除语句Word格式文档下载.docx》由会员分享，可在线阅读，更多相关《ERP数据库删除语句Word格式文档下载.docx（14页珍藏版）》请在冰点文库上搜索。

Ï

deletecustomer_shipwherecust_idnotin（'

default'

）

deletecashset_dtl

cashset_dtl'

deletecashset_mst

deletematerial_customer

material_customer'

DELETEFROMCUSTOMER_BILLTO

deletecustomer_dtl

wherecust_idnotin（'

deletecustomer_mst

deletecustomer_ship

deleteap_invoice_dtl

wherevend_idnotin（'

ap_invoice_dtl'

RESEED,0）

deleteap_invoice_mst

ap_invoice_mst'

deleteporv_dtl

GO

porv_dtl'

deleteporv_mst

deletematerial_vendor

material_vendor'

deleteap_match

whereVEND_IDnotin（'

ap_match'

deleteporder_dtl

porder_dtl'

deleteporder_mst

deleteap_tax

ap_tax'

deletepoir_dtl

poir_dtl'

deletepoir_mst

¡

deletevendor_dtl

deletevendor_mst

deletestock_history

stock_history'

deletematerial_multi_bill

deletemorder_dtl

morder_dtl'

deletemorder_mst

deletepick_bill

pick_bill'

deletepick_dtl

pick_dtl'

deletepick_mst

deletecost_dtlwhereitem<

'

cost_dtl'

deletecost_mstwhereitem<

cost_mst'

deletematerial_lotwhereitem<

deletematerial_dtl2whereitem<

deletematerial_dtl1whereitem<

deleteprice_list_dtl

price_list_dtl'

deleteprice_list_mst

deleteunits_measurewhereitem<

deletematerial_mstwhereitem<

deletebill_history

bill_history'

deletegl_je_dtl

gl_je_dtl'

deletegl_je_mst

deletestock_inventory

stock_inventory'

GO¡

deletematerial_bill

deleteDESIGN_BILL

deleteORDER_ROUTING

ORDER_ROUTING'

deleteROUTING

ROUTING'

deleteMORV_MST

deletePOIR_QI_DTL

deleteMATERIAL_PROVE

deletelot_mst

lot_mst'

truncatetablesys_log

deleteinva_dtl

inva_dtl'

deleteinva_mst

deletejournal_batch

journal_batch'

deletematerial_fcst_consume

material_fcst_consume'

DELETEFROMSTOCK_FROZEN_HISTORY

go

STOCK_FROZEN_HISTORY'

DELETEFROMORDER_DTL_MRP

ORDER_DTL_MRP'

DELETEFROMMORV_DTL

MORV_DTL'

DELETEFROMSUGGESTION_MRP

SUGGESTION_MRP'

DELETEFROMSTOCK_FROZEN

STOCK_FROZEN'

DELETEFROMMATERIAL_SAFETY

MATERIAL_SAFETY'

DELETEFROMSTOCK_BIN

DELETEFROMSTOCK_STK

DELETEFROMIMTR_DTL

DELETEFROMIMTR_MST

DELETEFROMMANUFACTURE_CNFGWHEREPLANT<

00000'

DELETEFROMLOT_CNFGWHEREPLANT<

DELETEFROMPLANTSWHEREPLANT<

DELETEFROMPURCHASE_CNFGWHEREPURCHASE<

DELETEFROMAP_CNFGWHEREPURCHASE<

DELETEFROMAP_AGEWHEREPURCHASE<

DELETEFROMPURCHASE_PLANTWHEREPURCHASE<

DELETEFROMPURCHASE_ORGWHEREPURCHASE<

deletefromORDER_ROUTING_MRP

ORDER_ROUTING_MRP'

SELECT*

FROMTICKET_MAXIMUM

UPDATETICKET_MAXIMUMSETMAXIMUM=0

DELETEFROMSTOCK_WIP_BALANCE

DELETEFROMSTOCK_BALANCE

DELETEFROMSTOCK_WIP_JOURNAL

DELETEFROMSTOCK_JOURNAL

DELETEFROMMORDER_SHORT

DELETEFROMAP_APPLY

DELETEFROMSERIALNO

DELETEFROMHEATNO

DELETEFROMMOMTCHECK_DTL

DELETEFROMLEVEL_PICK_BILL

DELETEFROMCORDER_STAT_LOG

DELETEFROMLABOR_FEEDBACK

LABOR_FEEDBACK'

DELETEFROMROUTING_OPERATIONS

ROUTING_OPERATIONS'

DELETEFROMPICK_BILL_MRP

DELETEFROMGL_TOTAL_AMT

DELETEFROMMOMTCHECK_MST

DELETEFROMGL_BALANCE

DELETEFROMORG_MEMBERWHERECOMPANY<

ORG_MEMBER'

DELETEFROMORG_DTLWHERECOMPANY<

ORG_DTL'

DELETEFROMORG_MSTWHERECOMPANY<

DELETEFROMGL_ACT_MEMBERWHERECOMPANY<

GL_ACT_MEMBER'

DELETEFROMGL_ACT_DTLWHERECOMPANY<

GL_ACT_DTL'

DELETEFROMGL_ACT_MSTWHERECOMPANY<

select*

fromusers

deletefromuserswhereuser_idnotin（'

admin'

'

zhb'

FROMEMPLOYEE_MST

FROMVENDOR_DTL

deletefromEMPLOYEE_MSTwhereEMPLOYEE_IDnotin（'

DEFAULT'

DEFU1'

fromREASON_ACCT

deletefromREASON_ACCT

REASON_ACCT'

fromREASON_DUE

fromREASON_MST

deletefromREASON_MSTwherereason_idnotin（'

999'

FROMSTD_OPERATION

DELETEFROMOPERATION_MST

DELETEFROMWORKCENTER_MSTWHEREWC_NONOTIN（'

1'

2'

3'

4'

5'

6'

7'

8'

9'

10'

DELETEFROMSTD_OPERATIONWHEREOP_ID<

FROME

USE[WTEST6]

DBCCSHRINKDATABASE（N'

WTEST6'

）

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'