Synopsis
DROP [PUBLIC] SYNONYM
[schema
.]synonym_name
Removes a public or private synonym
(synonym_name) from the database.
Keyword
- PUBLIC
Specifies that the synonym to be dropped is a public synonym.
Notes
The synonym to be dropped must be in your schema, or you must have
the DROP ANY SYNONYM privilege to remove a synonym from another
schema or the DROP ANY PUBLIC SYNONYM privilege to remove a public
synonym.
Example
The following example removes the public synonym employee from the
database:
DROP PUBLIC SYNONYM employee