Error 1000123

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

Item Description

SQLCode

-1000123L

Constant

EMSG_MCINDEX_NEEDS_DISTINCT_COLS

SQLState

QDB23

ODBC 2 State

ERROR

ODBC 3 State

ERROR

Sybase Error Code

20783

Severity Code

14

Parameter 1

The name of the index being created.

Parameter 2

Location of the exception.

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