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:
| Setting | Description |
|---|---|
|
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). |