DROP VIEW Statement

statement_DROP_VIEW ::= DROP [ IF EXISTS ] VIEW [scheme.]query_name

Description

This statement deletes a query stored in the database. The query name can be specified along with the schema name in the following form:

schema.query_name

If the query of the specified name does not exist in the schema, the error sqlstate W0137 (OBJECT_DOES_NOT_EXIST) occurs.

602SQL Variations

Deletion of dependent objects from the schema using RESTRICT | CASCADE are not implemented.

Example:

DROP VIEW Salaries

See