Remove a view
DROP VIEW [IF EXISTS] view-name
The DROP VIEW statement removes a view created by the CREATE VIEW statement. Although the view is removed from the database schema, no data in the underlying tables are modified.