Chapter 3 Building Physical Diagrams

Naming a foreign key constraint

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

Variable Description
%REFRNAME% Name of the reference
%REFRCODE% Code of the reference
%PARENT% Code of the parent table
%CHILD% Code of the child table

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

Steps To name a foreign key constraint:

  1. Double-click a reference in the diagram to open its property sheet.
  2. Click the Integrity tab and 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.

  3. Click OK in each of the dialog boxes.

 

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