Chapter 4 Building Physical Diagrams
You can modify an object's properties from its property sheet. To open a key property sheet, go to the Keys tab of its parent table, or double-click its Browser entry.
The General tab contains the following properties:
| Property | Description |
|---|---|
| Name | Specifies the name of the item, which should be clear and meaningful, and should convey the item's purpose to non-technical users |
| Code | Specifies the technical name of the object, which is used for generating code or scripts, which may be abbreviated, and should not generally include spaces |
| Comment | Specifies the descriptive comment for the key |
| Stereotype | Sub-classification used to extend the semantics of an object without changing its structure; it can be predefined or user-defined |
| Table | Specifies the name of the table where the key is defined |
| Constraint name | Specifies the name of the key constraint. PowerDesigner automatically creates a constraint name for a key, it is used during database creation and modification. You can modify the default name, you can also cancel these changes and go back to the default name |
| Primary key | Indicates if the key is the primary key of the current table. There must be only one primary key in a table, if you select the Primary Key check box in a key property sheet, it replaces an already existing primary key |
| Cluster | Indicates whether the key constraint is a clustered constraint (for those DBMS that support clustered indexes) |
| Copyright (C) 2008. Sybase Inc. All rights reserved. |
| |