DROP VIEW
Removes a view.
Synopsis
DROP VIEW [IF EXISTS] <name. [, ...] [CASCADE | RESTRICT]
Description
DROP VIEW
will remove an existing view. Only the owner of a view can remove it.
Parameters
Examples
Remove the view topten
;
DROP VIEW topten;
Compatibility
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 HAWQ extension.