Removes a view.
DROP VIEW [IF EXISTS] <name> [, ...] [CASCADE | RESTRICT]
DROP VIEW
will remove an existing view. Only the owner of a view can remove it.
Remove the view topten
;
DROP VIEW topten;
DROP VIEW
is fully conforming with the SQL standard, except that the standard only allows one view to be dropped per command. Also, the IF EXISTS
option is a Greenplum Database extension.
Parent topic: SQL Command Reference