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 HAWQ extension.