Variables for Indexes and Index Columns

%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

%ASC%

Contains keywords "ASC" or "DESC" depending on sort order

%ISASC%

TRUE if index column sort is ascending