2.20 DROP VIEW

---

Description

Deletes the view from the database.

Syntax

DROP VIEW [owner_name.]view_name ;

Notes

If owner_name is specified and is different from the name of the user executing the statement, then the user must have DBA privileges.
When a view is dropped, other views that are dependent on this view are not dropped. The dependent views become invalid.

Example

DROP VIEW newcustomers ;

Authorization

The user executing this statement must have any of the following privileges:

DBA privilege
Ownership of the view

SQL Compliance	SQL-92, ODBC Core SQL grammar
Environment	Embedded SQL, interactive SQL, ODBC applications
Related Statements	CREATE VIEW