Chapter 3 DBMS Reference Guide

ConstName

Allows the declaration of a customizable template for all the alternate key constraint names in a PDM. It is used in the Key property sheet for all the keys that are alternate keys and not primary keys.

For each table in a model, an alternate key constraint name is defined in the Key properties entry Key Constraint Name for a key defined as alternate key. This constraint name is generated in the database if the database supports alternate keys and constraint names.

Some PowerDesigner variables can be used to define alternate key constraint name:

• %TABLE%: table code
• %KEY%: key code

There is an automatic renaming of duplicate constraint names according to the length of the constraint.

Example

In Sybase Adaptive Server Anywhere 6:

AK_%.U18:AKEY%_%.U8:TABLE%

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