DROP_ADE_DB.sql

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

-- -------------------------------------------------------------------- 
-- FWEB_buildingsurvey 
-- -------------------------------------------------------------------- 
ALTER TABLE FWEB_buildingsurvey
    DROP CONSTRAINT FWEB_buildingsurvey_fk;

ALTER TABLE FWEB_buildingsurvey
    DROP CONSTRAINT FWEB_buildings_objectcl_fk;

ALTER TABLE FWEB_buildingsurvey
    DROP CONSTRAINT FWEB_buildi_build_consi_fk;

-- -------------------------------------------------------------------- 
-- FWEB_energysurvey 
-- -------------------------------------------------------------------- 
ALTER TABLE FWEB_energysurvey
    DROP CONSTRAINT FWEB_energysurvey_fk;

ALTER TABLE FWEB_energysurvey
    DROP CONSTRAINT FWEB_energy_build_energ_fk;

-- -------------------------------------------------------------------- 
-- FWEB_foodsurvey 
-- -------------------------------------------------------------------- 
ALTER TABLE FWEB_foodsurvey
    DROP CONSTRAINT FWEB_foodsurvey_fk;

ALTER TABLE FWEB_foodsurvey
    DROP CONSTRAINT FWEB_foodsu_build_foods_fk;

-- -------------------------------------------------------------------- 
-- FWEB_watersurvey 
-- -------------------------------------------------------------------- 
ALTER TABLE FWEB_watersurvey
    DROP CONSTRAINT FWEB_watersurvey_fk;

ALTER TABLE FWEB_watersurvey
    DROP CONSTRAINT FWEB_waters_build_water_fk;

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

-- -------------------------------------------------------------------- 
-- FWEB_buildingsurvey 
-- -------------------------------------------------------------------- 
DROP TABLE FWEB_buildingsurvey;

-- -------------------------------------------------------------------- 
-- FWEB_energysurvey 
-- -------------------------------------------------------------------- 
DROP TABLE FWEB_energysurvey;

-- -------------------------------------------------------------------- 
-- FWEB_foodsurvey 
-- -------------------------------------------------------------------- 
DROP TABLE FWEB_foodsurvey;

-- -------------------------------------------------------------------- 
-- FWEB_watersurvey 
-- -------------------------------------------------------------------- 
DROP TABLE FWEB_watersurvey;

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