Sybase Error – Index ‘%2’ cannot be created. Multicolumn indexes must be created using distinct columns. %1

In this blog post, you’ll learn more about the Sybase Error Index ‘%2’ cannot be created. Multicolumn indexes must be created using distinct columns. %1 and the reason for receiving this error

Sybase SQL Error Message

Index ‘%2’ cannot be created. Multicolumn indexes must be created using distinct columns. %1

Reason for this Error

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