Variables for Indexes

%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