Syntax
The DROP SYNONYM statement has the following format:
[EXEC SQL] DROP SYNONYM [IF EXISTS] [schema.]synonym_name {, [schema.]synonym_name};
IF EXISTS
Suppresses error reporting for the specified object if the object does not exist or exists but is not owned by you.The IF EXISTS clause is typically used prior to issuing the corresponding CREATE statement to ensure that the CREATE statement does not fail due to an existing object of that type.
synonym_name
Specifies the name of the synonym to be removed.