DROP SYNONYM

Syntax

Purpose

To remove a synonym from the database, or to change the definition of a synonym by dropping and re-creating it.

See Also: "CREATE SYNONYM" for more information on synonyms.

Prerequisites

To drop a private synonym, either the synonym must be in your own schema or you must have the DROP ANY SYNONYM system privilege.

To drop a PUBLIC synonym, either the synonym must be in your own schema or you must have the DROP ANY PUBLIC SYNONYM system privilege.

Keywords and Parameters

PUBLIC	must be specified to drop a public synonym. You cannot specify schema if you have specified PUBLIC.
schema	is the schema containing the synonym. If you omit schema, Oracle assumes the synonym is in your own schema.
synonym	is the name of the synonym to be dropped. If you drop a synonym for a materialized view, or its containing table or snapshot, or any of its dependent tables, the materialized view will be invalidated.

Example

To drop a synonym named MARKET, issue the following statement:

DROP SYNONYM market;