PowerDesigner can use variables in the generation and reverse-engineering of index columns.
Variable
Comment
%ASC%
Contains Keywords "ASC" or "DESC" depending on sort order
%ISASC%
TRUE if Index column sort is ascending