What is a synonym?

A synonym is an alternative name tables, views, sequences and other database objects.

Oracle - What is a synonym? - April 10, 2009 at 11:00 AM

What is a synonym?  

Synonym simplifies the use of the table, the table for which synonym is created can be referred by synonym name.

Example
create synonym Emp
for Employees;

In the above example Emp is the synonym created for the employees table. Employees now can also be referred by Emp.

Also read

Oracle Synonym

Table references can be complicated. So oracle allows you create synonym for a complicated reference. It renames a table reference..........

What are Schema Objects?

Schema objects are the logical database structure that represents database's data. Schema objects include tables, views, sequences, synonyms, indexes, clusters, database............

<<Previous  Next>>

Write your comment - Share Knowledge and Experience