Delete a view.


<drop view statement> ::=

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


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


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.


1) The following example deletes the teachers_view view:

       DROP VIEW IF EXISTS teachers_view


SQL:2003 standard

NexusDB extensions



Core SQL

IF EXISTS clause

Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | SQL Statements | Schema Statements