The DROP VIEW
statement is used to delete a view.
DROP VIEW [IF EXISTS] view_name, [, view_name] ...
Parameter
view_name
: the name of the view. You can prefix a schema name to the view name to distinguish
between the views that have the same name but belong to different schemas.
Example
You can delete the finished_orders_v1 view by executing the following statement:
DROP VIEW tpch.finished_orders_v1;