3.3.28 CREATE SYNONYM

Table of Contents Previous Next


3 The SQL Language : 3.3 SQL Commands : 3.3.28 CREATE SYNONYM

CREATE SYNONYM -- define a new synonym
CREATE [OR REPLACE] [PUBLIC] SYNONYM [schema.]syn_name
FOR
object_schema.object_name[@dblink_name];
CREATE SYNONYM defines a synonym for certain types of database objects. Advanced Server supports synonyms for:
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. If you do not specify a schema name, the synonym is created in the first existing schema in your search path.
object_name specifies the name of the object.
object_schema specifies the name of the schema that the referenced object resides in.
dblink_name specifies the name of the database link through which an object is accessed.
Include the REPLACE clause to replace an existing synonym definition with a new synonym definition.
Include the PUBLIC clause to create the synonym in the public schema. The CREATE PUBLIC SYNONYM command, compatible with Oracle databases, creates a synonym that resides in the public schema:
CREATE [OR REPLACE] PUBLIC SYNONYM syn_name FOR object_schema.object_name;
CREATE [OR REPLACE] SYNONYM public.syn_name FOR object_schema.object_name;
Create a synonym for the emp table in a schema named, enterprisedb:

3 The SQL Language : 3.3 SQL Commands : 3.3.28 CREATE SYNONYM

Table of Contents Previous Next