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