SSMS 17.3: New Feature: Synonyms 1. Provide an Abstraction layer for database Objects 2. Means we can hide main schema and its relating objects with synonyms Example is given below :
When executed both queries they provided same data and behavior.
Benefits: if end user want to access data we can hide physical object names and assign only synonyms rights against that user. Insert delete update on Synonyms: Insert delete update can be done on a synonymed table.