Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


Synonyms


A synonym is an alternative name for a table, view or another synonym. Synonyms can be created or dropped at any time.

Using synonyms can be a convenient way to address tables that are contained in another schema.

For example, if a view customer_details is contained in the schema mimer_store, the full name of the view is mimer_store.customer_details.

This view may be referenced from another schema mimer_store_book by its fully qualified name as given above. Alternatively, a synonym may be created for the view in schema mimer_store_book, e.g. cust_details. Then the name cust_details can simply be used to refer to the view.


Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX