Name

DropGeometryTable — Drops a spatial table and its references in the metadata table geometry_columns.

Synopsis

varchar DropGeometryTable(varchar catalogue, varchar schema, varchar table);

varchar DropGeometryTable(varchar schema, varchar table);

varchar DropGeometryTable(varchar table);

Description

Drops a spatial table and its references in the metadata table geometry_columns.

Coordinate Dimensions
2D3DM
Spatial Standards Support
OGC SFS for SQL. 1.1 (1999)OGC SFS for SQL. 1.1.0 (2005)OGC SFS for SQL. 1.2.0 (2006)SQL-MM Part 3
----

Examples

PostgreSQL
--Drops test Table and all its constraints.
SELECT DropGeometryTable ('test');
H2
SELECT DropGeometryTable ('TEST');

Related functions

AddGeometryColumn