Navigation:  NexusDB Guide > SQL Reference > SQL Statements > Schema Statements >

UPDATE ALIAS statement

Previous pageReturn to chapter overviewNext page

NexusDB V3 Manual

UPDATE ALIAS statement

button_main button_prev button_next

NexusDB Manual V3 > SQL Reference > SQL Statements > Schema Statements

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 Database Systems Pty Ltd.

nexus_logo