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.
See Also
Other Resources
Using Synonyms (Database Engine)
CREATE SYNONYM (Transact-SQL)
Getting Information About Synonyms
User-Schema Separation