DROP_ADE_DB.sql

-- This document was automatically created by the ADE-Manager tool of 3DCityDB (https://www.3dcitydb.org) on 2021-01-10 14:56:23 
-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 
-- *********************************** Drop foreign keys ********************************** 
-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 
-- -------------------------------------------------------------------- 
-- FWEA_areasurvey 
-- -------------------------------------------------------------------- 
ALTER TABLE FWEA_areasurvey
    DROP CONSTRAINT FWEA_areasurvey_fk;

ALTER TABLE FWEA_areasurvey
    DROP CONSTRAINT FWEA_areasurve_objectcl_fk;

ALTER TABLE FWEA_areasurvey
    DROP CONSTRAINT FWEA_areasu_fwear_consi_fk;

-- -------------------------------------------------------------------- 
-- FWEA_energysurvey 
-- -------------------------------------------------------------------- 
ALTER TABLE FWEA_energysurvey
    DROP CONSTRAINT FWEA_energysurvey_fk;

ALTER TABLE FWEA_energysurvey
    DROP CONSTRAINT FWEA_energy_areas_energ_fk;

-- -------------------------------------------------------------------- 
-- FWEA_foodsurvey 
-- -------------------------------------------------------------------- 
ALTER TABLE FWEA_foodsurvey
    DROP CONSTRAINT FWEA_foodsurvey_fk;

ALTER TABLE FWEA_foodsurvey
    DROP CONSTRAINT FWEA_foodsu_areas_foods_fk;

-- -------------------------------------------------------------------- 
-- FWEA_fwearea 
-- -------------------------------------------------------------------- 
ALTER TABLE FWEA_fwearea
    DROP CONSTRAINT FWEA_fwearea_fk;

ALTER TABLE FWEA_fwearea
    DROP CONSTRAINT FWEA_fwearea_lod0multis_fk;

-- -------------------------------------------------------------------- 
-- FWEA_watersurvey 
-- -------------------------------------------------------------------- 
ALTER TABLE FWEA_watersurvey
    DROP CONSTRAINT FWEA_watersurvey_fk;

ALTER TABLE FWEA_watersurvey
    DROP CONSTRAINT FWEA_waters_areas_water_fk;

-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 
-- *********************************** Drop tables *************************************** 
-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 
-- -------------------------------------------------------------------- 
-- FWEA_areasurvey 
-- -------------------------------------------------------------------- 
DROP TABLE FWEA_areasurvey;

-- -------------------------------------------------------------------- 
-- FWEA_energysurvey 
-- -------------------------------------------------------------------- 
DROP TABLE FWEA_energysurvey;

-- -------------------------------------------------------------------- 
-- FWEA_foodsurvey 
-- -------------------------------------------------------------------- 
DROP TABLE FWEA_foodsurvey;

-- -------------------------------------------------------------------- 
-- FWEA_fwearea 
-- -------------------------------------------------------------------- 
DROP TABLE FWEA_fwearea;

-- -------------------------------------------------------------------- 
-- FWEA_watersurvey 
-- -------------------------------------------------------------------- 
DROP TABLE FWEA_watersurvey;

-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 
-- *********************************** Drop Sequences ************************************* 
-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++