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.

   <source lang="sql">

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