To view or edit a key's properties, double-click its Browser or list entry. The property sheet tabs and fields listed here are those available by default, before any customization of the interface by you or an administrator.
Property |
Description |
---|---|
Name/Code/Comment |
Identify the object. The name should clearly convey the object's purpose to non-technical users, while the code, which is used for generating code or scripts, may be abbreviated, and should not normally include spaces. You can optionally add a comment to provide more detailed information about the object. By default the code is generated from the name by applying the naming conventions specified in the model options. To decouple name-code synchronization, click to release the = button to the right of the Code field. |
Stereotype |
Extends the semantics of the object. You can enter a stereotype directly in this field, or add stereotypes to the list by specifying them in an extension file. |
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) |
Keywords |
Provide a way of loosely grouping objects through tagging. To enter multiple keywords, separate them with commas. |