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 SYNONYM statement

The ALTER SYNONYM statement defines changes to be made to a Db2 synonym definition.

GUID-4F5DF073-0F4C-4F67-A35F-416BA147BAF7-low.png

ALTER SYNONYM synonymOwner 1 .synonymName 1

This option specifies the fully qualified name of the synonym to be changed.

OWNER synonymOwner 2

This option specifies the new owner of the synonym.

NAME synonymName 2

This option specifies the new name of the synonym.

TABLE

This option specifies the new table or view that the synonym references.

TABLE parameter values

Value

Description

tableOwner.tableName

Specifies the name of a table.

viewOwner.viewName

Specifies the name of a view.

Related topic

CDL-statements



 

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