You can execute the DROP VIEW statement to delete a view.
Syntax
DROP VIEW [IF EXISTS] view_name, [, view_name] ... Parameters
view_name: the name of the view to be deleted. You can use the prefix of the database name
to distinguish views with the same name within different databases.
Example
Delete the view named v.
DROP VIEW v;