Chapter 3 Building Physical Diagrams

Naming an alternate key constraint

You can use the following variable in the name of a alternate key constraint:

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 open its property sheet.
  2. Click the Keys tab, select an alternate key, and click the Properties tool to open its property sheet.
  3. Enter the required name in the Constraint Name box.

    The User-Defined button to the right of the Constraint box is pressed automatically. You can return to the default constraint name by re-clicking the User-Defined button.

  4. Click OK in each of the dialog boxes.

 

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