NexusDB Guide > SQL Reference > SQL Statements > Schema Statements

NexusDB V3 Manual

CREATE ALIAS statement

Define a persistent viewed table.

Syntax

<alias definition> ::=

CREATE ALIAS AliasName FROM {<path_name> | MEMORY}

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

Usage

The CREATE ALIAS statements creates a alias / schema on the server.

Notes

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

§	When MEMORY is specified the alias will be an in-memory database only.

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

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

Examples

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

CREATE ALIAS test_alias FROM 'c:\test' ENFORCE

Conformance

NexusDB extensions

CREATE ALIAS statement

nexus_logo