• Article

Synonym Properties (General Page)

A synonym is an alternative name for a table, view, stored procedure, or function. Create a synonym when you must refer to an object by more than one name. A synonym can be used in queries and stored procedures in place of the original four-part object name.

Options

  • Synonym name
    Type the new name you will use for this object.

  • Synonym schema
    Type the schema of the new name you will use for this object.

  • Server name
    Type the server instance to connect to.

  • Database name
    Type or select the database containing the object.

  • Schema
    Type or select the schema that owns the object.

  • Object type
    Select the type of object.

  • Object name
    Type the name of the object to which the synonym refers.

Note

To change an existing synonym, drop and recreate the synonym.