Sybase Error – CMP index can only be created on two distinct columns having identical datatypes. %1

In this blog post, you’ll learn more about the Sybase Error CMP index can only be created on two distinct columns having identical datatypes. %1 and the reason for receiving this error

Sybase SQL Error Message

CMP index can only be created on two distinct columns having identical datatypes. %1

Reason for this Error

A CMP index is an index that can be only created on two columns. You cannot create a single column CMP index; nor can you create a CMP index on three or more columns. Furthermore, when specifying two columns, the two columns must have identical datatypes.

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this blog post, you’ll learn more about the Sybase Error No plan. HTML_PLAN function is not supported for this...
In this blog post, you’ll learn more about the Sybase Error Division by zero and the reason for receiving this...
In this blog post, you’ll learn more about the Sybase Error Incorrect or missing encryption key and the reason for...