🏚️Xoá dữ liệu kho

Xoá dữ liệu kho về mặc định

• Chay CSDL

// RUN CSDL Cần xoá
USE VTTECHDEMO

• Chạy Query

-- Kiểm tra dữ liệu
SELECT * FROM VTT_Product
SELECT * FROM VTT_Product_Type
SELECT * FROM VTT_Product_Reciept
SELECT * FROM VTT_Product_Reciept_Detail
SELECT * FROM VTT_Product_Export
SELECT * FROM VTT_Product_Export_Detail
SELECT * FROM VTT_Product_Unit
SELECT * FROM VTT_Product_ExportTS
SELECT * FROM VTT_Product_ExportTS_Detail
SELECT * FROM VTT_WareHouse_Lock
SELECT * FROM VTT_WareHouse_Lock_Detail
SELECT * FROM VTT_Service_MapProduct

SELECT * FROM VTT_Product_OrderForm
SELECT * FROM VTT_Product_OrderForm_Detail

SELECT * FROM VTT_Product_Properties

--TRUNCATE TABLE  VTT_Product
--TRUNCATE TABLE  VTT_Product_Type

--TRUNCATE TABLE  VTT_Product_Reciept
--TRUNCATE TABLE  VTT_Product_Reciept_Detail

--TRUNCATE TABLE  VTT_Product_Export
--TRUNCATE TABLE  VTT_Product_Export_Detail

--TRUNCATE TABLE  [VTT_Product_Unit]

--TRUNCATE TABLE  VTT_Product_ExportTS 
--TRUNCATE TABLE  VTT_Product_ExportTS_Detail

--TRUNCATE TABLE  VTT_WareHouse_Lock
--TRUNCATE TABLE  VTT_WareHouse_Lock_Detail

--TRUNCATE TABLE VTT_Service_MapProduct
 
--TRUNCATE TABLE VTT_Product_OrderForm_Detail
--TRUNCATE TABLE VTT_Product_OrderForm
--TRUNCATE TABLE VTT_Product_Properties


SELECT * FROM VTT_WareHouse
SELECT * FROM VTT_Supplier
SELECT * FROM VTT_Supplier_Deposit_Use
SELECT * FROM VTT_Supplier_Desposit
SELECT * FROM VTT_Supplier_Payment
SELECT * FROM VTT_Supplier_PaymentDetail
SELECT * FROM VTT_Product_Group


--TRUNCATE TABLE VTT_WareHouse
--TRUNCATE TABLE VTT_Supplier
--TRUNCATE TABLE VTT_Supplier_Deposit_Use
--TRUNCATE TABLE VTT_Supplier_Desposit
--TRUNCATE TABLE VTT_Supplier_Payment
--TRUNCATE TABLE VTT_Supplier_PaymentDetail
--TRUNCATE TABLE VTT_Product_Group