ALTER ALIAS statement

The ALTER ALIAS statement specifies changes to the definition of an alias.

GUID-88CAF2D6-08DF-4901-A558-B986CEA27572-low.png

ALTER ALIAS aliasOwner 1 .aliasName 1

This option specifies the fully qualified name of the alias to be modified.

OWNER aliasOwner 2

This option specifies the new owner of the alias.

NAME aliasName 2

This option specifies the new name of the alias.

TABLE

This option specifies the fully qualified name or name of the table or view that the alias references. The following table lists valid values for the TABLE parameter.

TABLE parameter values

Value

Description

locationID.tableOwner.tableName

Specifies the fully qualified name of the table that the alias references.

tableOwner.tableName

Specifies the name of the table that the alias references.

locationID.viewOwner.viewName

Specifies the fully qualified name of the view that the alias references.

viewOwner.viewName

Specifies the name of a view that the alias references.

COMMENT 'string'

This option specifies a comment for the alias.

NOCOMMENT

This option removes an existing comment.

LABEL 'string'

This option specifies a label for the alias.

NOLABEL

This option removes an existing label.


Related topic

CDL-statements



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*