Name
CREATE/DROP SYNONYM
Synopsis
CREATE Syntax:
CREATE [PUBLIC] SYNONYMsynonym_nameFOR [schema.]object_name[@dblink]
DROP Syntax:
DROP [PUBLIC] SYNONYM [schema.]synonym_nameCreates or removes a public or private synonym for a database object.
Keywords
- PUBLIC
Specifies that this synonym will be available to all users. If omitted, the synonym will be available only to the schema owner.
- synonym_name
Name of the new synonym.
- object_name
Name of the object to which the synonym will refer. It may include a reference to a remote database by appending the @dblink syntax.
Tip
Oracle resolves object names in the current schema first, so a PUBLIC synonym will be used only if the object name is not prefaced with a schema name, is not followed by a dblink, and does not exist in the current schema.
Common keywords and clauses: dblink, schema.