Synonym Properties (General Page)

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.

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.

ms187639.note(en-US,SQL.90).gifNote:
To change an existing synonym, drop and recreate the synonym.

Community Additions

ADD
Show:
© 2016 Microsoft