Table of Contents Previous Next


2 The SQL Language : 2.3 SQL Commands : 2.3.51 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.
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 DROP PUBLIC SYNONYM command, compatible with Oracle databases, drops a synonym that resides in the public schema:

2 The SQL Language : 2.3 SQL Commands : 2.3.51 DROP SYNONYM

Table of Contents Previous Next