Chapter 3 Building Physical Diagrams

Naming a foreign key constraint

In the name of a foreign key constraint, you can use the following variables:

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.

    The property sheet for the reference appears.
  2. Click the Integrity tab.

    The Integrity page appears. It displays referential integrity information for the reference.
  3. 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.



  4. Click OK in each of the dialog boxes.

 

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