DropGeometryTable
Name
DropGeometryTable — Drops a table and all its references in geometry_columns.
Synopsis
boolean
DropGeometryTable
(
varchar
table_name
)
;
boolean
DropGeometryTable
(
varchar
schema_name
, varchar
table_name
)
;
boolean
DropGeometryTable
(
varchar
catalog_name
, varchar
schema_name
, varchar
table_name
)
;
Description
Drops a table and all its references in geometry_columns. Note: uses current_schema() on schema-aware pgsql installations if schema is not provided.
|
|
|
|
Changed: 2.0.0. Retained for
backward compatibility after
geometry_columns
became a
view of the system catalogs.
Examples
Use standard SQL to drop a table containing geometry columns. The
geometry_columns
view updates automatically.
DROP TABLE my_schema.my_spatial_table;
The legacy compatibility function performs the equivalent operation.
SELECT DropGeometryTable ('my_schema', 'my_spatial_table');
my_schema.my_spatial_table dropped.