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*