Delete a view.

 

Syntax

 

<drop view statement> ::=

 

 

 

DROP VIEW [ IF EXISTS ] [ schema-name. ] view-name [ RESTRICT ]

 

 

Usage

 

The DROP VIEW statement deletes the view specified by view-name from the database.

 

 

Notes

 

The current database is implicit if a schema name is not specified.



 

The IF EXISTS clause can be specified to avoid an exception when attempting to delete a view that does not exist in the database.



 

RESTRICT, which is implicit if not explicitly specified, prevents the view from being deleted if the view is referenced by other database objects.



 

The DROP VIEW statement requires exclusive access to the view being deleted.



 

 

Examples

 

1)

The following example deletes the teachers_view view:



 


DROP VIEW IF EXISTS teachers_view



 

 


 

Conformance

 

SQL:2003 standard

 

NexusDB extensions

-

 

-

Core SQL

 

IF EXISTS clause