[postgis-users] How to drop a PostGIS table ?

Nicolas Ribot nicky666 at gmail.com
Tue Jul 12 10:56:05 PDT 2005

>  Hello, 
> I would like how to drop a PostGIS table on Postgresql. 
> Does anyone knows how to drop it and all the relations on the tables  "spatial_ref_sys" and "geometry_columns" 

Hi Ezequias,

There is a function that does the trick (as stated in the documentation) :

"DropGeometryTable([<schema_name>], <table_name>)

    Drops a table and all its references in geometry_columns. Note:
uses current_schema() on schema-aware pgsql installations if schema is
not provided."


More information about the postgis-users mailing list