Define a persistent viewed table.


<alias definition> ::=

CREATE ALIAS AliasName FROM {<path_name> | MEMORY}

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


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


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.


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



NexusDB extensions


CREATE ALIAS statement

Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | SQL Statements | Schema Statements