-- Script generated by Redgate Compare v1.45.1.2004
SET check_function_bodies = false;


DO LANGUAGE plpgsql $$BEGIN RAISE NOTICE 'Dropping public.vw_base_utility_delivered_quantity_by_sale_line...';END$$;
DROP VIEW public.vw_base_utility_delivered_quantity_by_sale_line;


DO LANGUAGE plpgsql $$BEGIN RAISE NOTICE 'Dropping public.vw_base_fact_sale_physical_contract...';END$$;
DROP VIEW public.vw_base_fact_sale_physical_contract;


DO LANGUAGE plpgsql $$BEGIN RAISE NOTICE 'Dropping public.vw_base_fact_purchase_physical_contract...';END$$;
DROP VIEW public.vw_base_fact_purchase_physical_contract;


DO LANGUAGE plpgsql $$BEGIN RAISE NOTICE 'Dropping public.vw_base_utility_shipped_quantity_by_purchase_line...';END$$;
DROP VIEW public.vw_base_utility_shipped_quantity_by_purchase_line;


DO LANGUAGE plpgsql $$BEGIN RAISE NOTICE 'Dropping public.vw_base_utility_intransit_quantity_by_purchase_line...';END$$;
DROP VIEW public.vw_base_utility_intransit_quantity_by_purchase_line;


DO LANGUAGE plpgsql $$BEGIN RAISE NOTICE 'Dropping public.vw_base_fact_movement...';END$$;
DROP VIEW public.vw_base_fact_movement;


DO LANGUAGE plpgsql $$BEGIN RAISE NOTICE 'Dropping public.vw_base_dim_shipment...';END$$;
DROP VIEW public.vw_base_dim_shipment;


DO LANGUAGE plpgsql $$BEGIN RAISE NOTICE 'Dropping public.vw_base_dim_physical_sale_contract...';END$$;
DROP VIEW public.vw_base_dim_physical_sale_contract;


DO LANGUAGE plpgsql $$BEGIN RAISE NOTICE 'Dropping public.vw_base_dim_physical_purchase_contract...';END$$;
DROP VIEW public.vw_base_dim_physical_purchase_contract;


DO LANGUAGE plpgsql $$BEGIN RAISE NOTICE 'Dropping public.vw_base_dim_product...';END$$;
DROP VIEW public.vw_base_dim_product;


DO LANGUAGE plpgsql $$BEGIN RAISE NOTICE 'Dropping public.vw_base_dim_lot...';END$$;
DROP VIEW public.vw_base_dim_lot;


DO LANGUAGE plpgsql $$BEGIN RAISE NOTICE 'Dropping public.vw_base_dim_location...';END$$;
DROP VIEW public.vw_base_dim_location;

SET check_function_bodies = true;