Error 1000173

"Index '%1' cannot be created. Multicolumn indexes must be created using distinct columns."

Item Description

SQLCode

-1000173L

Constant

EMSG_NEED_DISTINCT_COLUMNS

SQLState

QNA38

ODBC 2 State

ERROR

ODBC 3 State

ERROR

Sybase Error Code

20833

Severity Code

14

Parameter 1

The name of the index being created.

Probable cause

Multicolumn indexes must be created using distinct columns. That is, you cannot use the same column more than once when creating a multicolumn index.


Created May 6, 2011. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com