RENAME SYNONYM statement) 

The RENAME SYNONYM statement changes the name of a synonym.

Syntax

<rename synonym statement> ::= RENAME [PUBLIC] SYNONYM <old synonym name> TO <new synonym name>

old/new synonym name

Explanation

The old synonym name must have been generated by the current user.

If PUBLIC is specified, the old must be defined as PUBLIC.

A table of the current user with the new synonym name must not exist already.