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 shown by the
geometry_columns
view.
|
|
|
|
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.
Changed: 2.0.0. Retained for
backward compatibility after
geometry_columns
became a
view of the system catalogs.
Examples
Use standard SQL to drop the geometry column. The
geometry_columns
view updates automatically.
ALTER TABLE my_schema.my_spatial_table DROP COLUMN geom;
The legacy compatibility function performs the equivalent operation.
SELECT DropGeometryColumn ('my_schema', 'my_spatial_table', 'geom');
my_schema.my_spatial_table.geom effectively removed.