Physical Modeling › SQL Server Common Functionality › Define SQL Server Schemas

Previous Topic: Define SQL Server Users

Next Topic: Define SQL Server Stored Procedures

Define SQL Server Schemas

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

To define a SQL Server schema

  1. Click Target - SQL Server, Schemas on the Model 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 New icon in property editors to create a new object 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 Server 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 Server Schema Editor closes.

More information:

Define Permissions for an Object in a SQL Server Property Editor

Add a Comment in a Property Editor

Add a UDP in a SQL Server Physical Property Editor