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_detailsis contained in the schema
mimer_store, the full name of the view is
This view may be referenced from another schema
mimer_store_bookby its fully qualified name as given above. Alternatively, a synonym may be created for the view in schema
cust_details. Then the name
cust_detailscan simply be used to refer to the view.
Mimer Information Technology AB
Phone: +46 18 780 92 00