DROP TABLE river_axes;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'RIVER_AXES';
DROP TRIGGER river_axes_trigger;
DROP SEQUENCE RIVER_AXES_ID_SEQ;

DROP TABLE river_axes_km;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'RIVER_AXES_KM';
DROP TRIGGER river_axes_km_trigger;
DROP SEQUENCE RIVER_AXES_KM_ID_SEQ;

DROP TABLE cross_section_tracks;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'CROSS_SECTION_TRACKS';
DROP TRIGGER cross_section_tracks_trigger;
DROP SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ;

DROP TABLE lines;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'LINES';
DROP TRIGGER lines_trigger;
DROP SEQUENCE LINES_ID_SEQ;

DROP TABLE buildings;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'BUILDINGS';
DROP TRIGGER buildings_trigger;
DROP SEQUENCE BUILDINGS_ID_SEQ;

DROP TABLE fixpoints;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FIXPOINTS';
DROP TRIGGER fixpoints_trigger;
DROP SEQUENCE FIXPOINTS_ID_SEQ;

DROP TABLE floodplain;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODPLAIN';
DROP TRIGGER floodplain_trigger;
DROP SEQUENCE FLOODPLAIN_ID_SEQ;

DROP TABLE dem;
DROP TRIGGER dem_trigger;
DROP SEQUENCE DEM_ID_SEQ;

DROP TABLE catchment;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'CATCHMENT';
DROP TRIGGER catchment_trigger;
DROP SEQUENCE CATCHMENT_ID_SEQ;

DROP TABLE hws;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HWS';
DROP TRIGGER hws_trigger;
DROP SEQUENCE HWS_ID_SEQ;

DROP TABLE floodmaps;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODMAPS';
DROP TRIGGER floodmaps_trigger;
DROP SEQUENCE FLOODMAPS_ID_SEQ;