DropGeometryTable (original) (raw)
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.
| ![[Note]](http://postgis.net/docs/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 table with geometry columns like any other table using DROP TABLE | |
Examples
SELECT DropGeometryTable ('my_schema','my_spatial_table'); ----RESULT output --- my_schema.my_spatial_table dropped.
-- The above is now equivalent to -- DROP TABLE my_schema.my_spatial_table;