DROP VIEW statement is used to delete a view.
DROP VIEW [IF EXISTS] view_name, [, view_name] ...
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.
You can delete the finished_orders_v1 view by executing the following statement:
DROP VIEW tpch.finished_orders_v1;