Chapter 3 DBMS Reference Guide
Allows to declare a customizable template for all the foreign key constraint names in a PDM. It is used in the Reference property sheet, in the Constraint name entry on the Integrity tab.
For each table in a model, a foreign key constraint name is defined in the Reference properties entry Key Constraint Name for a key defined as foreign key. This constraint name is generated in the database if the database supports foreign keys and constraint names.
The following PowerDesigner variables can be used to define foreign key constraint name:
%TABLE%: table code (parent and child table, Version 6 compliant)
There is an automatic renaming of duplicate constraint names according to the length of the constraint.
FK_%.U8:CHILD%_%.U9:REFR%_%.U8:PARENT%
| Copyright (C) 2005. Sybase Inc. All rights reserved. |
| |