DROP ALIAS statement

Mon, 03/09/2009 - 21:59 |  hdanzl

Delete a view.


Syntax

<drop view statement> ::=

DROP ALIAS [ IF EXISTS ] alias-name


Usage

The DROP ALIAS deletes an alias / schema.


Notes

♦ The IF EXISTS clause can be specified to avoid an exception when attempting to delete an alias that does not exist.


Examples

1) The following example deletes the test_alias alias:

       DROP ALIAS IF EXISTS test_alias


Conformance

NexusDB extensions

-

IF EXISTS clause

DROP ALIAS statement
‹ ALTER ALIAS statementupDROP TABLE 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.