5.10 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 which 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