Dropping a View v2.0
You can drop both spatial and non-spatial views using pgAdmin III.
- Open pgAdmin III and connect to PostgreSQL as a user with admin role.
- Expand the node for your SDW, expand the Schemas entry, expand the schema the views in in, expand the VIews.
- Right click on the view you wish to drop
- Select Delete/Drop.
- You will be asked to confirm if you want the drop the view.
- Click Yes to drop the view.