Chapter 3 Building Physical Diagrams

Naming an alternate key constraint

In the name of an alternate key constraint, you can use the following variables:

Variable Description
%AK% Code of the alternate key
%AKNAME% Name of the alternate key
%TABLE% Code of the table

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

Steps To name an alternate 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 an alternate key.
  4. Click the Properties tool.

    The property sheet for the alternate 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 depressed automatically.

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