If you just want to provide an alias for a table or another object, you can use a synonym. Well, a view contains more complicated logic. Why would you use a synonym instead of a view?

The examples later in this article will demonstrate this further.Īs mentioned above, a synonym is an alias or alternative name for an object.Ī view object is an SQL query that is saved and run when other queries use that view. It also simplifies access to objects, especially when multiple databases and schemas are involved. You can provide access to an object to a user using a synonym, and you don’t need to worry about who owns the original object. The main reason is to simplify the user access to an object. Why would you want to create a synonym? Why not just rename the original object?

How to Find All Synonyms In the DatabaseĪ synonym is an object in a database that represents an alternative name for other objects, such as tables, views, sequences, and stored procedures.

Difference Between Public and Private Synonym in Oracle.

What is a synonym