经过实践检验的语句如下：
SELECT *
FROM ship_dtl
delete ship_dtl
DBCC CHECKIDENT ('ship_dtl', RESEED,0)
SELECT *
FROM ship_mst
delete ship_mst
SELECT *
FROM corder_dtl
delete corder_dtl
SELECT *
FROM corder_mst
delete corder_mst
DBCC CHECKIDENT ('corder_dtl', RESEED,0)
select *
from ar_invoice_dtl
delete ar_invoice_dtl where ar_ivc_no<>0
select *
from ar_invoice_mst
delete ar_invoice_mst where ar_ivc_no<>0
select *
from customer_ship
delete customer_ship where cust_id not in ('default')
select *
from cashset_dtl
delete cashset_dtl
DBCC CHECKIDENT ('cashset_dtl', RESEED,0)
select *
from cashset_mst
delete cashset_mst
select *
from material_customer
where cust_id not in ('default')
delete material_customer
DBCC CHECKIDENT ('material_customer', RESEED,0)
select *
from customer_dtl
delete customer_dtl
where cust_id not in ('default')
select *
from customer_mst
delete customer_mst
where cust_id not in ('default')
select *
from customer_ship
delete customer_ship
where cust_id not in ('default')
----------------------------------------------------------------------
select *
from ap_invoice_dtl
delete ap_invoice_dtl
where vend_id not in ('default')
DBCC CHECKIDENT ('ap_invoice_dtl', RESEED,0)
select *
from ap_invoice_mst
delete ap_invoice_mst
where vend_id not in ('default')
DBCC CHECKIDENT ('ap_invoice_mst', RESEED,0)
select *
from porv_dtl
delete porv_dtl
DBCC CHECKIDENT ('porv_dtl', RESEED,0)
select *
from porv_mst
delete porv_mst
select *
from material_vendor
delete material_vendor
where vend_id not in ('default')
DBCC CHECKIDENT ('material_vendor', RESEED,0)
select *
from ap_match
delete ap_match
where VEND_ID not in ('default')
DBCC CHECKIDENT ('ap_match', RESEED,0)
select *
from porder_dtl
delete porder_dtl
DBCC CHECKIDENT ('porder_dtl', RESEED,0)
select *
from porder_mst
delete porder_mst
select *
from ap_tax
delete ap_tax
where vend_id not in ('default')
DBCC CHECKIDENT ('ap_tax', RESEED,0)
select *
from poir_dtl
delete poir_dtl
DBCC CHECKIDENT ('poir_dtl', RESEED,0)
select *
from poir_mst
delete poir_mst
select *
from vendor_dtl
delete vendor_dtl
where vend_id not in ('default')
select *
from vendor_mst
delete vendor_mst
where vend_id not in ('default')
select *
from stock_history
delete stock_history
DBCC CHECKIDENT ('stock_history', RESEED,0)
select *
from material_multi_bill
delete material_multi_bill
select *
from morder_dtl
delete morder_dtl
DBCC CHECKIDENT ('morder_dtl', RESEED,0)
select *
from morder_mst
delete morder_mst
select *
from pick_bill
delete pick_bill
DBCC CHECKIDENT ('pick_bill', RESEED,0)
select *
from pick_dtl
delete pick_dtl
DBCC CHECKIDENT ('pick_dtl', RESEED,0)
select *
from pick_mst
delete pick_mst
select *
from material_lot
delete material_lot where item<>'default'
select *
from material_dtl2
delete material_dtl2 where item<>'default'
select *
from cost_dtl
delete cost_dtl where item<>'default'
DBCC CHECKIDENT ('cost_dtl', RESEED,0)
select *
from cost_mst
delete cost_mst where item<>'default'
DBCC CHECKIDENT ('cost_mst', RESEED,0)
select *
from material_dtl1
delete material_dtl1 where item<>'default'
select *
from price_list_dtl
delete price_list_dtl
DBCC CHECKIDENT ('price_list_dtl', RESEED,0)
select *
from price_list_mst
delete price_list_mst
select *
from units_measure
delete units_measure where item<>'default'
select *
from material_mst
delete material_mst where item<>'default'
select *
from bill_history
delete bill_history
DBCC CHECKIDENT ('bill_history', RESEED,0)
select *
from gl_je_dtl
delete gl_je_dtl
DBCC CHECKIDENT ('gl_je_dtl', RESEED,0)
select *
from gl_je_mst
delete gl_je_mst
select *
from stock_inventory
delete stock_inventory
DBCC CHECKIDENT ('stock_inventory', RESEED,0)
select *
from material_bill
delete material_bill
select *
from lot_mst
delete lot_mst
DBCC CHECKIDENT ('lot_mst', RESEED,0)
select *
from sys_log
truncate table sys_log
select *
from inva_dtl
delete inva_dtl
DBCC CHECKIDENT ('inva_dtl', RESEED,0)
select *
from inva_mst
delete inva_mst
select *
from journal_batch
delete journal_batch
DBCC CHECKIDENT ('journal_batch', RESEED,0)
select *
from material_fcst_consume
delete material_fcst_consume
DBCC CHECKIDENT ('material_fcst_consume', RESEED,0)
