Schemas (SQL Server)

For SQL Server 2005 and higher, schemas are distinct namespaces, separate from the users who created them, and can be transferred between users. PowerDesigner models schemas as users with a stereotype of <<Schema>>.

Creating a Schema

You can create a schema in any of the following ways:
  • Select Model > Users and Roles > Schemas to access the List of Schemas, and click the Add a Row tool.

  • Right-click the model (or a package) in the Browser, and select New > Schema.

Schema Properties

You can modify an object's properties from its property sheet. To open a schema property sheet, double-click its diagram symbol or its Browser entry in the Schemas folder.

The following extended attributes are available on the General tab:

Name

Description

Owner

Specifies the name of the database-level principal user that owns the schema. This user may own other schemas, any of which may be his default schema.

Scripting name: SchemaOwner