Key Properties

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)