CREATE ALIAS statement

Mon, 03/09/2009 - 21:59 |  hdanzl

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
‹ Schema StatementsupCREATE TABLE statement ›
Print this chapter |  Login or register to post comments |  Send to friend |  PDF version |  metadata Tags:
Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | SQL Statements | Schema Statements

Powered by Drupal and Drupal Theme created with Artisteer.