aboutsummaryrefslogtreecommitdiff
path: root/src/bin/pgaccess/lib/help/drop_view.hlp
blob: 0ad481167a9af429fd95bc8e86ffcc95664c512b (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
.pgaw:Help.f.t insert end "DROP VIEW" {bold} " drops an existing view from the database. To execute this command you must be the owner of the view. 

" {} "Synopsis" {bold} "

DROP VIEW view

" {} "Usage" {bold} "

This command will remove the view called kinds: 

DROP VIEW kinds;

" {} "Notes" {bold} "

The Postgres DROP TABLE statement also drops views. 

Refer to CREATE VIEW for information on how to create views. "