-- This document was automatically created by the ADE-Manager tool of 3DCityDB (https://www.3dcitydb.org) on 2021-03-29 18:00:36 
-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 
-- *********************************** 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 ************************************* 
-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 

PURGE RECYCLEBIN;
