NexusDB Guide > SQL Reference > SQL Statements > Schema Statements

NexusDB V3 Manual

UPDATE ALIAS statement

Define a persistent viewed table.

Syntax

<alias definition> ::=

UPDATE ALIAS AliasName SET TO <path_name>

<path_name> ::= <character string literal> [ ENFORCE ]

Usage

The UPDATE ALIAS statements changes an alias / schema on the server to a different directory.

Notes

§	The AliasName shall conform to the format rules for identifiers and schema-qualified names in NexusDB SQL.

§	The optional ENFORCE can be used to force the server to create the path.

§	Once updated, aliases can be used just like ordinary aliases.

Examples

1)	The following example changes an alias to c:\test_new. If the directory doesn't exist the server will create it:

UPDATE ALIAS test_alias FROM 'c:\test_new' ENFORCE

Conformance

NexusDB extensions

Support for the ORDER BY clause in <view definition>

nexus_logo