Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


CREATE SYNONYM


Creates an alternative name for a table, view or another synonym.

Usage

Embedded/Interactive/ODBC/JDBC.

Description

A synonym is created for the table, view or synonym specified in object-name.

If synonym-name is specified in its unqualified form, the synonym will be created in the schema which has the same name as the current ident.

If synonym-name is specified in its fully qualified form (i.e. schema-name.synonym-name) the synonym will be created in the named schema (in this case, the current ident must be the creator of the specified schema).

Restrictions

A synonym may only be created if the creator has some access privilege on the object specified in object-name.

A synonym can only be created for an existing table, view or synonym.

The synonym name may not be the same as the name of any other table, view or synonym already belonging to the schema in which the synonym is created.

Notes

The synonym is stored in the data dictionary and it may be used to refer to the associated table or view wherever object-name would normally be used in the syntax specifications for SQL.

Note: Synonyms are not the same as correlation names. The latter are defined in the FROM clause of select-specifications, see Select Specification, and apply only within the context of the statement where they are defined.

Standard Compliance

Standard
Compliance
Comments
X/Open-95
SQL92
MIMER EXTENSION
The CREATE SYNONYM statement is a Mimer SQL extension.
Note: Equivalent standard-compliant functionality can be achieved by creating a VIEW statement with no WHERE clause and granting the same access rights on the view as apply on the table.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Reference Manual TOC PREV NEXT INDEX