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.