DROP_ADE_DB.sql

-- This document was automatically created by the ADE-Manager tool of 3DCityDB (https://www.3dcitydb.org) on 2021-03-29 18:02:06 
-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 
-- *********************************** Drop foreign keys ********************************** 
-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 
-- -------------------------------------------------------------------- 
-- FWES_energysurvey 
-- -------------------------------------------------------------------- 
ALTER TABLE FWES_energysurvey
    DROP CONSTRAINT FWES_energysurvey_fk;

ALTER TABLE FWES_energysurvey
    DROP CONSTRAINT FWES_energy_syste_energ_fk;

-- -------------------------------------------------------------------- 
-- FWES_foodsurvey 
-- -------------------------------------------------------------------- 
ALTER TABLE FWES_foodsurvey
    DROP CONSTRAINT FWES_foodsurvey_fk;

ALTER TABLE FWES_foodsurvey
    DROP CONSTRAINT FWES_foodsu_syste_foods_fk;

-- -------------------------------------------------------------------- 
-- FWES_fwesystem 
-- -------------------------------------------------------------------- 
ALTER TABLE FWES_fwesystem
    DROP CONSTRAINT FWES_fwesystem_fk;

ALTER TABLE FWES_fwesystem
    DROP CONSTRAINT FWES_fwesystem_lod0mult_fk;

-- -------------------------------------------------------------------- 
-- FWES_systemsurvey 
-- -------------------------------------------------------------------- 
ALTER TABLE FWES_systemsurvey
    DROP CONSTRAINT FWES_systemsurvey_fk;

ALTER TABLE FWES_systemsurvey
    DROP CONSTRAINT FWES_systemsur_objectcl_fk;

ALTER TABLE FWES_systemsurvey
    DROP CONSTRAINT FWES_system_fwesy_consi_fk;

-- -------------------------------------------------------------------- 
-- FWES_watersurvey 
-- -------------------------------------------------------------------- 
ALTER TABLE FWES_watersurvey
    DROP CONSTRAINT FWES_watersurvey_fk;

ALTER TABLE FWES_watersurvey
    DROP CONSTRAINT FWES_waters_syste_water_fk;

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

-- -------------------------------------------------------------------- 
-- FWES_foodsurvey 
-- -------------------------------------------------------------------- 
DROP TABLE FWES_foodsurvey;

-- -------------------------------------------------------------------- 
-- FWES_fwesystem 
-- -------------------------------------------------------------------- 
DROP TABLE FWES_fwesystem;

-- -------------------------------------------------------------------- 
-- FWES_systemsurvey 
-- -------------------------------------------------------------------- 
DROP TABLE FWES_systemsurvey;

-- -------------------------------------------------------------------- 
-- FWES_watersurvey 
-- -------------------------------------------------------------------- 
DROP TABLE FWES_watersurvey;

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