    delete from i_bdecustomer;
    delete from i_customerenvinfo;
    delete from i_visitmonth;
    delete from i_costcenter;
    commit;
    delete from i_deliveryhistory;
    delete from i_turnover_plpc;
    delete from i_activestocklocation;
    delete from i_creditcard;
    delete from i_temporarydeliverystop;
    commit;
    delete from i_uniqueresitem;
    delete from i_client;
    delete from i_residentialplpc;
    delete from i_customerresidentialsettings;
    commit;
    delete from i_customeruserinstruction;
    delete from i_container;
    delete from i_weighingcategpercustomer;
    delete from i_taxauthorities;
    delete from i_taxdefinition;
    commit;
    delete from i_matorderinginfo;
    delete from i_stockroomquantity;
    delete from i_changesperweekrentprice;
    delete from i_customerstockcharge;
    delete from i_frequencyrelatedrentprices;
    delete from i_userdefinedemblem;
    commit;
    delete from i_onsiteinvadjustment;
    delete from i_deliverydays;
    delete from i_deliverystandards;
    commit;
    delete from i_deliveryvariation;
    delete from i_consumptionpoint;
    delete from i_department;
    delete from i_contactperson;
    delete from i_contactcalls;
    commit;
    delete from i_artransaction;
    delete from i_billtoaccount;
    delete from i_invoiceline;
    delete from i_invoiceheader;
    commit;
    delete from i_misccharge;
    delete from i_pricelist;
    delete from i_pricelistpercustomer;
    delete from i_productlistpercustomer;
    commit;
    delete from i_emblem;
    delete from i_soilreasonability;
    delete from i_soilticketline;
    delete from i_soilticket;
    commit;
    delete from i_onsiteinvadjustment;
    delete from i_workorderline;
    delete from i_workorder;
    delete from i_specialchargeperproduct;
    commit;
    delete from i_specialchargespercustomer;
    delete from i_taxauthorities;
    delete from i_taxdefinition;
    delete from i_uniquepool;
    commit;
    delete from i_uniqueitemflags;
    delete from i_uniqueitem;
    commit;
    delete from i_wearerinventory;
    delete from i_wearer;
    commit;
    delete from i_customer;
    delete from i_supplierproduct;
    delete from i_productsize;
    delete from i_product;
    commit;

-- Add/modify columns 
alter table I_DEPARTMENT modify DELIVERYPOINTNUMBER VARCHAR2(12);
alter table I_CONSUMPTIONPOINT modify DELIVERYPOINTNUMBER varchar2(12);
alter table I_WEARER modify DELIVERYPOINTNUMBER varchar2(12);