PowerDesigner can use variables in the generation and reverse-engineering of indexes.
|
Variable |
Comment |
|---|---|
|
%INDEX% |
Generated code of Index |
|
%TABLE% |
Generated code of the parent of an index, can be a table or a query table (view) |
|
%INDEXNAME% |
Index name |
|
%INDEXCODE% |
Index code |
|
%UNIQUE% |
Contains Keyword "unique" when Index is unique |
|
%INDEXTYPE% |
Contains Index type (available only for a few DBMS) |
|
%CIDXLIST% |
List of index columns with separator, on the same line. Example: A asc, B desc, C asc |
|
%INDEXKEY% |
Contains Keywords "primary", "unique" or "foreign" depending on Index origin |
|
%CLUSTER% |
Contains Keyword "cluster" when Index is cluster |
|
%INDXDEFN% |
Used for defining an index within a table definition |