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.

  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.
Parent topic: Naming Key Constraints

Created October 7, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com