
ingo@2854: DROP TABLE river_axes;
ingo@2854: DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'RIVER_AXES';
ingo@2854: DROP TRIGGER river_axes_trigger;
ingo@2854: DROP SEQUENCE RIVER_AXES_ID_SEQ;
ingo@2854: 
ingo@2854: DROP TABLE river_axes_km;
ingo@2854: DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'RIVER_AXES_KM';
ingo@2854: DROP TRIGGER river_axes_km_trigger;
ingo@2854: DROP SEQUENCE RIVER_AXES_KM_ID_SEQ;
ingo@2854: 
ingo@2854: DROP TABLE cross_section_tracks;
ingo@2854: DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'CROSS_SECTION_TRACKS';
ingo@2854: DROP TRIGGER cross_section_tracks_trigger;
ingo@2854: DROP SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ;
ingo@2854: 
ingo@2854: DROP TABLE lines;
ingo@2854: DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'LINES';
ingo@2854: DROP TRIGGER lines_trigger;
ingo@2854: DROP SEQUENCE LINES_ID_SEQ;
ingo@2854: 
ingo@2854: DROP TABLE buildings;
ingo@2854: DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'BUILDINGS';
ingo@2854: DROP TRIGGER buildings_trigger;
ingo@2854: DROP SEQUENCE BUILDINGS_ID_SEQ;
ingo@2854: 
ingo@2854: DROP TABLE fixpoints;
ingo@2854: DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FIXPOINTS';
ingo@2854: DROP TRIGGER fixpoints_trigger;
ingo@2854: DROP SEQUENCE FIXPOINTS_ID_SEQ;
ingo@2854: 
ingo@2854: DROP TABLE floodplain;
ingo@2854: DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODPLAIN';
ingo@2854: DROP TRIGGER floodplain_trigger;
ingo@2854: DROP SEQUENCE FLOODPLAIN_ID_SEQ;
ingo@2854: 
ingo@2854: DROP TABLE dem;
ingo@2854: DROP TRIGGER dem_trigger;
ingo@2854: DROP SEQUENCE DEM_ID_SEQ;
ingo@2854: 
ingo@2854: DROP TABLE catchment;
ingo@2854: DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'CATCHMENT';
ingo@2854: DROP TRIGGER catchment_trigger;
ingo@2854: DROP SEQUENCE CATCHMENT_ID_SEQ;
ingo@2854: 
ingo@2854: DROP TABLE hws;
ingo@2854: DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HWS';
ingo@2854: DROP TRIGGER hws_trigger;
ingo@2854: DROP SEQUENCE HWS_ID_SEQ;
ingo@2854: 
ingo@2854: DROP TABLE floodmaps;
ingo@2854: DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODMAPS';
ingo@2854: DROP TRIGGER floodmaps_trigger;
ingo@2854: DROP SEQUENCE FLOODMAPS_ID_SEQ;




