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
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