Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see ALTER and BMC AMI Change Manager for Db2 13.1.

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*