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>>.
Select Add a Row tool.
to access the List of Schemas, and click theRight-click the model (or a package) in the Browser, and select
.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 |