- Synonym is one of the object in SQL Server.
- Synonym is physical representation of data.
- We can’t create synonym based on more than one table.
- Synonym is invalid whenever table is dropped and changes the structure of table.
How to create synonym in SQL Server:
create synonym <synonym-name> for <table-name>
create synonym my_synonym for emp
// Here I am created synonym object with the name my_synonym on emp table.