DROP PUBLIC SYNONYM name [, ...]
DROP PUBLIC SYNONYM drops existing public synonyms. To execute this command you must be the owner of the public synonym or a super-user.
The name of a public synonym to be removed.
This command will remove the public synonym called, personnel:
DROP PUBLIC SYNONYM personnel;
CREATE PUBLIC SYNONYM