Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Azure Property Editors › SQL Azure Database Support in CA ERwin Data Modeler › Synonym Properties › Define SQL Azure Synonyms

Define SQL Azure Synonyms

SQL Azure supports the three-part name format database_name.[schema_name].object_name when the database_name is the current database or the database_name is tempdb and the object_name starts with #.

Note: SQL Azure does not support four-part names.

Use the SQL Azure Synonym Editor to define synonyms for database objects in a SQL Azure physical model.

To define SQL Azure synonyms

1. Click Target - SQL Azure, Synonyms on the Model menu.

   The SQL Azure Synonym Editor opens.

2. Select the synonym in the Navigation Grid that you want to define and work with the following options:

   Note: Click New on the toolbar to create a new synonym. Use the Enter filter text box to filter a very large list of synonyms to quickly locate the one that you want to define.

   Name

   Displays the synonym name. You can change the synonym name in this field.

   Schema

   Specifies the schema in which the synonym is created.

   Generate

   Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

3. Click the General tab and work with the following option:

   Object Name

   Defines the base object that the synonym references. Enter the information in this field.

4. Click the Permission tab and work with the following options:

   Note: Use the toolbar on this tab to create a new permission, delete a selected permission, or open the SQL Azure Permission Editor to work with permission properties.

   Name

   Displays the permission name. Change the name of the permission in this field.

   Type

   Specifies the permission type. Select the option from the drop-down list.

   Cascade

   Specifies the cascade action for the permission. Indicates that the permission revoked is also revoked from other principals to which it has been granted by this principal.

   With Grant

   Specifies if the user can grant this permission to other users or not.

   Grant As Principal

   Specifies the principal used to acquire the permissions. Select a principal from the drop-down list.

5. (Optional) Click the Comment tab and enter any comments that you want to associate with the synonym.
6. (Optional) Click the UDP tab to work with user-defined properties for the synonym.
7. (Optional) Click the Notes tab to view history information and view or edit user notes.
8. Click Close.

   The synonym is defined and the SQL Azure Synonym Editor closes.

More information:

Add a Comment in a Property Editor

Add a UDP in a Physical Property Editor

Edit User Notes or View Object History