You can execute the
DROP VIEW statement to delete a view.
DROP VIEW [IF EXISTS] view_name, [, view_name] ...
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.
Delete the view named v.
DROP VIEW v;