DROP VIEW -- remove a view
DROP VIEW name
DROP VIEW drops an existing view. To execute this command you must be the owner of the view. The named view will not be deleted if other objects are dependent upon this view (such as a view of a view).
name
The name (optionally schema-qualified) of the view to remove.
This command will remove the view called dept_30:
DROP VIEW dept_30;
See Also
