MySQL Tutorial/View/Drop View

Removing Views

To delete a view, use the DROP VIEW command.

DROP VIEW takes one argument: the name of the view to be dropped.

DROP VIEW [IF EXISTS] [<database>.]<name>