analytics/informix/extend/spatial.8.22.FC2/examples/sql/cleanup.sql

----------------------------------------------------------------------------
-- cleanup.sql
--
-- This script will remove all tables and spatial_references table entries
-- created by the sql examples.
----------------------------------------------------------------------------

DELETE FROM spatial_references WHERE srid >= 1000 AND srid <= 1005;

DROP TABLE airports;
DROP TABLE aus_locns;
DROP TABLE boundary_test;
DROP TABLE buildingfootprints;
DROP TABLE cities;
DROP TABLE closed_linestring;
DROP TABLE closed_mlinestring;
DROP TABLE convexhull_test;
DROP TABLE coorddim_test;
DROP TABLE dimension_test;
DROP TABLE empty_test;
DROP TABLE endpoint_test;
DROP TABLE envelope_test;
DROP TABLE equal_test;
DROP TABLE geometry_test;
DROP TABLE geometrytype_test;
DROP TABLE hazardous_sites;
DROP TABLE honeycomb;
DROP TABLE islands;
DROP TABLE issimple_test;
DROP TABLE jagged_lines;
DROP TABLE linestring_test;
DROP TABLE locatealong_test;
DROP TABLE locatebetween_test;
DROP TABLE lots;
DROP TABLE m_test;
DROP TABLE measure_test;
DROP TABLE mlinestring_test;
DROP TABLE multipoint_test;
DROP TABLE multipolygon_test;
DROP TABLE numpoints_test;
DROP TABLE point_test;
DROP TABLE pointn_test;
DROP TABLE polygon_test;
DROP TABLE relate_test;
DROP TABLE ring_linestring;
DROP TABLE sensitive_areas;
DROP TABLE sewerlines;
DROP TABLE srid_test;
DROP TABLE startpoint_test;
DROP TABLE threed_test;
DROP TABLE waterways;
DROP TABLE well_locations;
DROP TABLE x_test;
DROP TABLE y_test;
DROP TABLE z_test;