DROP VIEW statement

Wed, 03/04/2009 - 20:02 |  hdanzl

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
‹ DROP INDEX statementupDROP TRIGGER statement ›
Print this chapter |  Login or register to post comments |  Send to friend |  PDF version |  metadata Tags:
Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | SQL Statements | Schema Statements

Powered by Drupal and Drupal Theme created with Artisteer.