Chapter 3 DBMS Reference Guide
Allows to declare a customizable template for all the primary key constraint names in a PDM.
For each table in a model, the primary key constraint name is defined in the Key properties entry Key Constraint Name for the Key defined as the Primary key. This constraint name is generated in the database if the database supports primary keys and constraint names.
Some PowerDesigner variables can be used to define the primary key constraint name:
There is an automatic renaming of duplicate constraint names according to the length of the constraint.
%OID%
The %OID% variable used in some Def. files in Version 6 is no longer available. Object identifiers are coded on more than 20 characters, making them unusable for constraint names (often limited to 8 or 18 characters)
PKConstraintName = PK_%.U27:TABLE%
| Copyright (C) 2005. Sybase Inc. All rights reserved. |
| |