http://developer.mimer.com

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 The SELECT Specification, and apply only within the context of the statement where they are defined.

Example

 CREATE SYNONYM artists FOR mimer_store_music.artists;

Standard Compliance

Standard	Compliance	Comments
X/Open-95 SQL-92	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