🏚️Xoá dữ liệu khách hàng

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

• Chay CSDL

// RUN CSDL Cần xoá
USE VTTECHDEMO

• Chạy Query

--TRUNCATE TABLE VTT_Customer
--TRUNCATE TABLE VTT_Customer_Anamnesis_History
--TRUNCATE TABLE VTT_Customer_Assay

--TRUNCATE TABLE VTT_Customer_Card
--TRUNCATE TABLE VTT_Customer_Consult_Less

--TRUNCATE TABLE VTT_Customer_Delete
--TRUNCATE TABLE VTT_Customer_Desposit
--TRUNCATE TABLE VTT_Customer_Merge
--TRUNCATE TABLE VTT_Customer_History

--TRUNCATE TABLE [VTT_Customer_Image_Folder]
--TRUNCATE TABLE [VTT_Customer_Image_Folder_Image]

--TRUNCATE TABLE VTT_Customer_Labo
--TRUNCATE TABLE VTT_Customer_Labo_Value

--TRUNCATE TABLE VTT_Customer_Note
--TRUNCATE TABLE VTT_Customer_Patient_Record

--TRUNCATE TABLE VTT_Customer_Payment
--TRUNCATE TABLE VTT_Customer_Payment_Card
--TRUNCATE TABLE VTT_Customer_Payment_Detail
--TRUNCATE TABLE VTT_Customer_Payment_Medicine
--TRUNCATE TABLE VTT_Customer_Prescription_Medicine
--TRUNCATE TABLE VTT_Customer_Prescription_Medicine_Detail
--TRUNCATE TABLE VTT_Customer_Relationship
--TRUNCATE TABLE VTT_Customer_Status
--TRUNCATE TABLE VTT_Customer_Status_Dental
--TRUNCATE TABLE VTT_Customer_StatusTeeth
--TRUNCATE TABLE VTT_Customer_StatusTeeth_Detail


--TRUNCATE TABLE VTT_Customer_Tab
--TRUNCATE TABLE VTT_Customer_Tab_Commission
--TRUNCATE TABLE VTT_Customer_Card_Commission
--TRUNCATE TABLE VTT_Customer_Tele_Commission
--TRUNCATE TABLE VTT_Customer_Treatment_Commission
--TRUNCATE TABLE VTT_Customer_Treatment_Less
--TRUNCATE TABLE VTT_Customer_Treatment_Text      
--TRUNCATE TABLE VTT_Customer_Treatment_Work
--TRUNCATE TABLE VTT_Customer_Tab_Treatment_Plan

--TRUNCATE TABLE VTT_CustomerCare_Value
--TRUNCATE TABLE VTT_CustomerCare_Value_Detail

--TRUNCATE TABLE VTT_Ticket
--TRUNCATE TABLE VTT_Ticket_Import
--TRUNCATE TABLE VTT_Ticket_Schedule
--TRUNCATE TABLE VTT_Ticket_Value
--TRUNCATE TABLE VTT_TicketMove


--TRUNCATE TABLE VTT_Schedule
--TRUNCATE TABLE VTT_Schedule_Cancel
--TRUNCATE TABLE VTT_Schedule_Note
--TRUNCATE TABLE VTT_Schedule_RealTime


--TRUNCATE TABLE VTT_Customer_Properties
--TRUNCATE TABLE VTT_Customer_Properties_Detail
--TRUNCATE TABLE VTT_Printform_Storage
--TRUNCATE TABLE VTT_Customer_Dynamic
--TRUNCATE TABLE VTT_Customer_Dynamic_Detail
--TRUNCATE TABLE VTT_Customer_Measure
--TRUNCATE TABLE VTT_Customer_MeasureDetail
--TRUNCATE TABLE VTT_Customer_Diagnose
--TRUNCATE TABLE VTT_Customer_Diagnose_Detail
--TRUNCATE TABLE VTT_Customer_Insurance
--TRUNCATE TABLE VTT_Customer_InsuranceDetail
--TRUNCATE TABLE VTT_Customer_Anamnesis_History