-- ¶©µ¥
|
truncate table POOrder
|
truncate table dbo.POOrderEntry
|
truncate table dbo.ICSubContract
|
truncate table dbo.ICSubContractEntry
|
truncate table dbo.POInStock
|
truncate table dbo.POInStockEntry
|
--¸¶¿îÉêÇëµ¥
|
TRUNCATE TABLE t_rp_PayApplyBillEntry
|
TRUNCATE TABLE t_rp_PayApplyBill
|
--²É¹º·¢Æ±
|
truncate table dbo.ICPurchase
|
truncate table dbo.ICPurchaseEntry
|
DELETE FROM dbo.t_RP_Contact WHERE FType =4
|
--¿â´æÀàµÄµ¥¾Ý¶¼ÔÚÒ»ÕÅ±í£¬É¾³ýËùÓпâ´æµ¥¾Ýºó£¬ÐèҪɾ³ý´æ»õºËËãÓà¶î±íºÍ¼´Ê±¿â´æ±í
|
ALTER TABLE ICStockBill DISABLE TRIGGER ALL
|
DELETE FROM dbo.ICStockBill
|
DELETE FROM dbo.ICStockBillEntry
|
ALTER TABLE ICStockBill ENABLE TRIGGER ALL
|
TRUNCATE TABLE dbo.ICBal
|
TRUNCATE TABLE dbo.ICInvBal
|
TRUNCATE TABLE dbo.ICInventory
|
TRUNCATE TABLE ICInvInitial
|
TRUNCATE TABLE POInvBal
|
TRUNCATE TABLE dbo.POInventory
|
--ÐèÈ«²¿É¾³ýºó£¬Ðè¸üÐÂÆôÓÃÆÚ¼äºóÕËÌײÅÄÜ¿ªÊ¼Ê¹ÓÃ
|
