Dropping a View v2.0

You can drop both spatial and non-spatial views using pgAdmin III.

  1. Open pgAdmin III and connect to PostgreSQL as a user with admin role.

  2. Expand the node for your SDW, expand the Schemas entry, expand the schema the views in in, expand the VIews.

  3. Right click on the view you wish to drop 



  4. Select Delete/Drop.

  5. You will be asked to confirm if you want the drop the view.


  6. Click Yes to drop the view.