Product Documentation

SQL Reference Guide

Previous Topic

Next Topic

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

TOCIndex