Online Documentation for SQL Manager for SQL server
You can use Synonyms in place of their referenced base object in a number of SQL statements and expression contexts. When working with synonyms in these contexts, the base object is affected. For example, if you have a synonym that references a base object that is a table, when you insert a row into the synonym, you are actually inserting a row into the referenced table.
Synonym Editor allows you to define synonym properties. It opens automatically when you create a new synonym and is available on editing an existing one.
To open a synonym in Synonym Editor, double-click it in the DB Explorer tree.
- Using Navigation bar and Toolbar
- Creating/editing synonym
- Browsing object dependencies
- Editing synonym description
- Viewing DDL definition
- Setting object permissions