ALTER ALIAS statement

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

Change an alias path.


Syntax

<alter alias statement> ::=

ALTER ALIAS alias_name <alter table action>
<alter table action> ::=

SET PATH TO <path_name>

| SET NAME TO new_alias_name
<path_name> ::= <character string literal> [ ENFORCE ]


Usage

The ALTER 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 altered, 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 it will be created:

       ALTER ALIAS test_alias SET PATH TO 'c:\test_new' ENFORCE

       


Conformance

NexusDB extensions

-

Support for the ALTER ALIAS
‹ ALTER TABLE statementupDROP ALIAS 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.