ERP数据库删除语句.docVIP

ERP数据库删除语句.txt生活是一张千疮百孔的网，它把所有激情的水都漏光了。寂寞就是你说话时没人在听，有人在听时你却没话说了！ERP数据库删除语句.txt遇事潇洒一点，看世糊涂一点。相亲是经销，恋爱叫直销，抛绣球招亲则为围标。没有准备请不要开始，没有能力请不要承诺。爱情这东西，没得到可能是缺憾，不表白就会有遗憾，可是如果自不量力，就只能抱憾了。 delete ship_dtl GO DBCC CHECKIDENT (ship_dtl, RESEED,0) GO delete ship_mst GO delete corder_dtl GO DBCC CHECKIDENT (corder_dtl, RESEED,0) GO delete corder_mst GO delete ar_invoice_dtl where ar_ivc_no0 GO delete ar_invoice_mst where ar_ivc_no0 GO --执行完毕 delete customer_ship where cust_id not in (default) GO delete cashset_dtl GO DBCC CHECKIDENT (cashset_dtl, RESEED,0) GO delete cashset_mst GO delete material_customer GO DBCC CHECKIDENT (material_customer, RESEED,0) GO DELETE FROM CUSTOMER_BILLTO GO delete customer_dtl where cust_id not in (default) GO delete customer_mst where cust_id not in (default) GO delete customer_ship where cust_id not in (default) GO delete ap_invoice_dtl where vend_id not in (default) GO DBCC CHECKIDENT (ap_invoice_dtl, RESEED,0) GO delete ap_invoice_mst where vend_id not in (default) GO DBCC CHECKIDENT (ap_invoice_mst, RESEED,0) GO delete porv_dtl GO DBCC CHECKIDENT (porv_dtl, RESEED,0) GO delete porv_mst GO delete material_vendor where vend_id not in (default) GO DBCC CHECKIDENT (material_vendor, RESEED,0) GO delete ap_match where VEND_ID not in (default) GO DBCC CHECKIDENT (ap_match, RESEED,0) GO delete porder_dtl GO DBCC CHECKIDENT (porder_dtl, RESEED,0) GO delete porder_mst GO delete ap_tax where vend_id not in (default) GO DBCC CHECKIDENT (ap_tax, RESEED,0) GO delete poir_dtl GO DBCC CHECKIDENT (poir_dtl, RESEED,0) GO delete poir_mst GO 　　 delete vendor_dtl where vend_id not in (default) GO delete vendor_mst where vend_id not in (default) GO 　　 delete stock_history GO DBCC CHECKIDENT (stock_history, RESEED,0) GO delete material_multi_bill GO delete morder_dtl GO DBCC CHECKIDENT (morder_dtl, RES