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

Define SQL Azure Schemas

Use the SQL Azure Schema Editor to define the schema for a database in a SQL Azure physical model.

To define a SQL Azure schema

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

   The SQL Azure Schema Editor opens.

2. Select the schema 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 schema. Use the Enter filter text box to filter a very large list of schemas to quickly locate the one that you want to define.

   Name

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

   Owner

   Specifies the role or user that owns the schema. Select the owner from the drop-down list.

   Generate

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

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

   Note: Use the options on the toolbar to create a new permission, delete a selected permission, or open the SQL Azure Permission Editor to manage 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.

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

   The schema is defined and the SQL Azure Schema Editor closes.

More information:

Define Permissions for an Object in a SQL Azure Property Editor

Add a Comment in a Property Editor

Add a UDP in a Physical Property Editor

Edit User Notes or View Object History