DROP VIEW

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.