DROP VIEW

Remove a view

Synopsis:



DROP VIEW [IF EXISTS] view-name

Description:

The DROP VIEW statement removes a view created by the CREATE VIEW statement. The name specified is the view name. It is removed from the database schema, but no actual data in the underlying base tables is modified.