Physical Modeling › SQL Server Physical Property Editors › SQL Server Database Objects › Define SQL Server Schemas

Define SQL Server Schemas

Use the SQL Server Schema Editor to define the schema for a database in a SQL Server 2005/2008 physical model.

To define a SQL Server schema

1. Click Schemas on the Database menu.

   The SQL Server 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.

   • 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: Click New on the toolbar to create a new permission.

   • 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. Click Close.

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