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:54:48 
-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 
-- *********************************** Drop foreign keys ********************************** 
-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 
-- -------------------------------------------------------------------- 
-- FWEL_energysurvey 
-- -------------------------------------------------------------------- 
ALTER TABLE FWEL_energysurvey
    DROP CONSTRAINT FWEL_energysurvey_fk;

ALTER TABLE FWEL_energysurvey
    DROP CONSTRAINT FWEL_energy_landu_energ_fk;

-- -------------------------------------------------------------------- 
-- FWEL_foodsurvey 
-- -------------------------------------------------------------------- 
ALTER TABLE FWEL_foodsurvey
    DROP CONSTRAINT FWEL_foodsurvey_fk;

ALTER TABLE FWEL_foodsurvey
    DROP CONSTRAINT FWEL_foodsu_landu_foods_fk;

-- -------------------------------------------------------------------- 
-- FWEL_land_use 
-- -------------------------------------------------------------------- 
ALTER TABLE FWEL_land_use
    DROP CONSTRAINT FWEL_land_use_fk;

-- -------------------------------------------------------------------- 
-- FWEL_landusesurvey 
-- -------------------------------------------------------------------- 
ALTER TABLE FWEL_landusesurvey
    DROP CONSTRAINT FWEL_landusesurvey_fk;

ALTER TABLE FWEL_landusesurvey
    DROP CONSTRAINT FWEL_landusesu_objectcl_fk;

ALTER TABLE FWEL_landusesurvey
    DROP CONSTRAINT FWEL_land_land_use_cons_fk;

-- -------------------------------------------------------------------- 
-- FWEL_watersurvey 
-- -------------------------------------------------------------------- 
ALTER TABLE FWEL_watersurvey
    DROP CONSTRAINT FWEL_watersurvey_fk;

ALTER TABLE FWEL_watersurvey
    DROP CONSTRAINT FWEL_waters_landu_water_fk;

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

-- -------------------------------------------------------------------- 
-- FWEL_foodsurvey 
-- -------------------------------------------------------------------- 
DROP TABLE FWEL_foodsurvey;

-- -------------------------------------------------------------------- 
-- FWEL_land_use 
-- -------------------------------------------------------------------- 
DROP TABLE FWEL_land_use;

-- -------------------------------------------------------------------- 
-- FWEL_landusesurvey 
-- -------------------------------------------------------------------- 
DROP TABLE FWEL_landusesurvey;

-- -------------------------------------------------------------------- 
-- FWEL_watersurvey 
-- -------------------------------------------------------------------- 
DROP TABLE FWEL_watersurvey;

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