Table of Contents Previous Next


3 The SQL Language : 3.3 SQL Commands : 3.3.39 DROP SYNONYM

DROP SYNONYM -- remove a synonym
DROP [PUBLIC] SYNONYM [schema.]syn_name
DROP SYNONYM deletes existing synonyms. To execute this command you must be a superuser or the owner of the synonym, and have USAGE privileges on the schema in which the synonym resides. See Section 2.2.4 for additional information about synonyms.
syn_name is the name of the synonym. A synonym name must be unique within a schema.
schema specifies the name of the schema that the synonym resides in.
You can optionally include the PUBLIC clause to drop a synonym that resides in the public schema. The Oracle-compatible DROP PUBLIC SYNONYM command drops a synonym that resides in the public schema:

3 The SQL Language : 3.3 SQL Commands : 3.3.39 DROP SYNONYM

Table of Contents Previous Next