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 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 .
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
|