Chapter 3 DBMS Reference Guide

AddColIndex

Statement for adding a column in the Create Index statement. This parameter defines each column in the column list of the Create Index statement.

Example

In Sybase Adaptive Server Anywhere 6:

AddColIndex = %COLUMN% [%ASC%]

%COLUMN% is the code of the column defined in the column list of the table. %ASC% is ASC (ascending order) or DESC (descending order) depending on the Sort radio button state for the index column.

Copyright (C) 2005. Sybase Inc. All rights reserved.