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 Seek failed: the requested segment offset %2 is outside...
In this blog post, you’ll learn more about the Sybase Error No indicator variable provided for NULL result and the...
In this blog post, you’ll learn more about the Sybase Error %2: Memory & disk block number mismatch; buffer={%3} page={%4}....