NexusDB Guide > SQL Reference > SQL Statements > Schema Statements

NexusDB V3 Manual

DROP ALIAS statement

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 VIEW IF EXISTS test_alias

Conformance

NexusDB extensions

IF EXISTS clause

DROP ALIAS statement

nexus_logo