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;