EMS logo

Products Navigation

SQL Manager for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

On-line Documentation

Synonyms


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.