DropGeometryColumn
Name
DropGeometryColumn — Removes a geometry column from a spatial table.
Synopsis
text
DropGeometryColumn
(
varchar
table_name
, varchar
column_name
)
;
text
DropGeometryColumn
(
varchar
schema_name
, varchar
table_name
, varchar
column_name
)
;
text
DropGeometryColumn
(
varchar
catalog_name
, varchar
schema_name
, varchar
table_name
, varchar
column_name
)
;
Description
Removes a geometry column from a spatial table. Note that schema_name will need to match the f_table_schema field of the table's row in the geometry_columns table.
This method implements the
OGC Simple Features
Implementation Specification for SQL 1.1.
This function supports 3d and will not drop the z-index.
This method supports Circular Strings and Curves.
![[Note]](./images/note.png)
|
|
|
Changed: 2.0.0 This function is provided for backward compatibility. Now that since geometry_columns is now a view against the system catalogs,
you can drop a geometry column like any other table column using
|
Examples
SELECT DropGeometryColumn ('my_schema','my_spatial_table','geom');
----RESULT output ---
dropgeometrycolumn
------------------------------------------------------
my_schema.my_spatial_table.geom effectively removed.
-- In PostGIS 2.0+ the above is also equivalent to the standard
-- the standard alter table. Both will deregister from geometry_columns
ALTER TABLE my_schema.my_spatial_table DROP column geom;