PowerDesigner can use variables in the generation and reverse-engineering of keys.
|
Variable |
Comment |
|---|---|
|
%COLUMNS% or %COLNLIST% |
List of columns of Key. Ex: "A, B, C" |
|
%ISPKEY% |
TRUE when Key is Primary key of Table |
|
%PKEY% |
Constraint name of primary key |
|
%AKEY% |
Constraint name of alternate key |
|
%KEY% |
Constraint name of the key |
|
%ISMULTICOLN% |
True if the key has more than one column |
|
%CLUSTER% |
Cluster keyword |