Deleting a View

 

Last but not least, to delete a view, we use the DROP VIEW keywords. The syntax is

 

DROP VIEW [IF EXISTS] name_of_view;

 

To delete myView, we write

 

DROP VIEW IF EXISTS myView;