Syntax:
DROP VIEW [ IF EXISTS ] [catalog-name.]view-name
The DROP VIEW statement removes a view created by the CREATE VIEW statement. It is removed from the database schema, but no data in the underlying tables is modified.