Alter synonyms

You can use the ALTER SYNONYM command to rename or change the owner of a synonym.

The syntax for the ALTER SYNONYM command is:

ALTER SYNONYM synonym_name RENAME TO new_synonym_name;
ALTER SYNONYM synonym_name OWNER TO new_owner;

For example, to rename the synonym for PEMP in database PROD, enter:

prod.sch1(admin)=> ALTER SYNONYM pemp RENAME TO p;

For example, to change the owner of the synonym pemp in database PROD, enter:

prod.sch1(admin)=> ALTER SYNONYM pemp OWNER TO leslie;