Synonyms Wizard (SQL Server)
Go Up to Microsoft SQL Server Object Wizards
This wizard builds and submits a CREATE SYNONYM statement, letting you build a one-part name that can be used in SQL statements instead of a fully-qualified, multi-part name.
To create a new synonym using a wizard:
- Open a creation wizard for a synonym. For details, see Opening an Object Wizard.
- Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
- Properties panel - for details, see Synonyms (SQL Server) - Properties.
- Permissions panel - Setting Permissions or Privileges for an Object
- DDL View panel - for details, see Previewing the DDL Generated to Create the New Object.
- Finally, use the Execute button to create the object.
Synonyms (SQL Server) - Properties
When creating a synonym, this tab/panel lets you provide a synonym name and fully qualify the object name that it references. When editing a synonym, this tab/panel lets you view the synonym definition.
- Note: Before creating or editing a synonym, consult Microsoft SQL Server documentation for information on topics such as support for specific function and procedure types, and three-part and four-part name restrictions. For assistance, see Accessing Third Party Documentation.
The following table describes the available settings:
Schema and Name
Use these setting to select an owner and type the one-part name that will be used to reference
Server, Database, Referenced Object Type, Referenced Object Owner, and Referenced Object Name
Use these setting to select the specific object to which the synonym is to refer. Optionally, you can use the server, database, and owner settings to construct a partially-qualified to fully-qualified name for the object. The user interface will allow you to construct all valid, multi-part name variations (for example: server.database.owner.object, database.owner.object, owner.object, server...object).