PostGIS
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.
|
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;