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;