TRUNCATE TABLE address_portal;
TRUNCATE TABLE asset_trans_details;
TRUNCATE TABLE asset_trans_header;
TRUNCATE TABLE barcode_transaction_table;
TRUNCATE TABLE bed_audit;
TRUNCATE TABLE call_logs;
TRUNCATE TABLE cart_detail;
TRUNCATE TABLE cart_header;
TRUNCATE TABLE case_details;
TRUNCATE TABLE complain_log_status;
TRUNCATE TABLE complain_logs;
TRUNCATE TABLE contact_portal;
TRUNCATE TABLE daily_subtask_vital_map;
TRUNCATE TABLE daily_subtasks;
TRUNCATE TABLE daily_tasks;
TRUNCATE TABLE departmentwise_consumption_items;
TRUNCATE TABLE departmentwise_consumptions;
TRUNCATE TABLE doc_id_portal;
TRUNCATE TABLE doctor_ip_transaction;
TRUNCATE TABLE doctor_signup_transaction;
TRUNCATE TABLE doctors_audit;
TRUNCATE TABLE emergency_details;
TRUNCATE TABLE good_receipt_details;
TRUNCATE TABLE icd_codewise_prescriptions;
TRUNCATE TABLE ipd_admission;
TRUNCATE TABLE ipd_bed_charge_details;
TRUNCATE TABLE ipd_bed_details;
TRUNCATE TABLE ipd_birth_records;
TRUNCATE TABLE ipd_case_visit_transfer;
TRUNCATE TABLE ipd_discharge_details;
TRUNCATE TABLE ipd_patient_consultant;
TRUNCATE TABLE ipd_patient_consultant_visit;
TRUNCATE TABLE item_stock;
TRUNCATE TABLE items_audit;
TRUNCATE TABLE lab_analyte_comments;
TRUNCATE TABLE lab_booking;
TRUNCATE TABLE lab_booking_details;
TRUNCATE TABLE lab_booking_tat;
TRUNCATE TABLE lab_report_attachments;
TRUNCATE TABLE lab_report_result;
TRUNCATE TABLE login_attempts;
TRUNCATE TABLE next_ofkin_portal;
TRUNCATE TABLE opd_doctor_appointments;
TRUNCATE TABLE organization_asset_maintenance;
TRUNCATE TABLE ot_bookings;
TRUNCATE TABLE ot_staff_details;
TRUNCATE TABLE package_dispatch_receive_details;
TRUNCATE TABLE patient_advance_balance;
TRUNCATE TABLE patient_login;
TRUNCATE TABLE patient_payments;
TRUNCATE TABLE patient_portal;
TRUNCATE TABLE patient_registration_log;
TRUNCATE TABLE patient_request;
TRUNCATE TABLE patient_rule_map;
TRUNCATE TABLE patient_service_charge_details;
TRUNCATE TABLE patient_service_charges;
TRUNCATE TABLE patient_service_charges_shadow;
TRUNCATE TABLE patient_symptom_disease;
TRUNCATE TABLE patient_vitals;
TRUNCATE TABLE payment_gateway_reference;
TRUNCATE TABLE pharmacy_billing_header;
TRUNCATE TABLE pharmacy_billing_item;
TRUNCATE TABLE pharmacy_return_header;
TRUNCATE TABLE pharmacy_return_items;
TRUNCATE TABLE prescriptions;
TRUNCATE TABLE prescriptions_wise_observations;
TRUNCATE TABLE prescriptionwise_medicine_test;
TRUNCATE TABLE purchase_order_items;
TRUNCATE TABLE purchase_order_receipt_items;
TRUNCATE TABLE purchase_order_receipts;
TRUNCATE TABLE purchase_order_return_items;
TRUNCATE TABLE purchase_order_returns;
TRUNCATE TABLE purchase_orders;
TRUNCATE TABLE purchase_requisitions;
TRUNCATE TABLE purchase_requisitions_details;
TRUNCATE TABLE rule_criteria;
TRUNCATE TABLE rule_logics;
TRUNCATE TABLE rule_master;
TRUNCATE TABLE service_category_audit;
TRUNCATE TABLE service_items_audit;
TRUNCATE TABLE service_sub_categories_audit;
TRUNCATE TABLE shift_assignments;
TRUNCATE TABLE staff_attendance;
TRUNCATE TABLE staff_leave_request;
TRUNCATE TABLE staff_monthly_payslip;
TRUNCATE TABLE stock_item_requisition;
TRUNCATE TABLE symptom_disease_audit;
TRUNCATE TABLE task_staff_assignments;
TRUNCATE TABLE taskwise_assignment_tracker;
TRUNCATE TABLE tmp_charges;
TRUNCATE TABLE tmp_group_permissions;
TRUNCATE TABLE tmp_lab_grp_analytes;
TRUNCATE TABLE tpa_patient_claim_workflow;
TRUNCATE TABLE tpa_payment_dtls;
TRUNCATE TABLE vendor_payments;
TRUNCATE TABLE visit_details;
TRUNCATE TABLE visitor_book;
TRUNCATE TABLE visitor_card_issue;
TRUNCATE TABLE visitor_card_issue_details;
TRUNCATE TABLE vitals_audit;
TRUNCATE TABLE waste_collection_bins;
TRUNCATE TABLE waste_collection_items;
TRUNCATE TABLE waste_collections;
