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;
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;