Chapter 3 Building Physical Diagrams

Naming a primary key constraint

A primary key constraint is a named check that enforces the uniqueness and the presence of values in a primary key column.

In the name of a primary key constraint, you can use the following variable:

For a full list of all variables that you can use in PowerDesigner, see the appendix Variables in PowerDesigner.

To name a primary key constraint:

1. Double-click a table in the diagram to display the table property sheet.
2. Click the Keys tab.
   
   The Keys page appears. It lists keys defined for the table.
3. Select the primary key.
4. Click the Properties tool.
   
   The property sheet for the primary key appears.
5. Type changes to the name in the Constraint Name box.
   
   The User-Defined button at the end of the Constraint box is pressed automatically.
   
   
      Undo changes to a constraint name
   You can always return to the default constraint name by re-clicking the User-Defined button.
   
   
   
   
6. Click OK in each of the dialog boxes.

Copyright (C) 2005. Sybase Inc. All rights reserved.