Synonyms Editor (SQL Server)

From DBArtisan
Jump to: navigation, search

Go Up to Microsoft SQL Server Object Editors

The Synonyms Editor lets you view the basic definition and work with dependencies of a partition scheme.

To edit a synonym:

  1. Open an editor on the synonym. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks


Lets you view the Schema, Name, Server, Database, Referenced Object Type, Referenced Object Owner, and Referenced Object Name properties for the synonym. For more information on these properties, see Synonyms (SQL Server) - Properties. This tab also includes a CreateDate property showing the data and time the synonym was created.


For details on using this tab, see Working with Object Dependencies.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.