Sybase Error – Cannot create %1 HG index because one already exists on the given columns.

In this blog post, you’ll learn more about the Sybase Error Cannot create %1 HG index because one already exists on the given columns. and the reason for receiving this error

Sybase SQL Error Message

Cannot create %1 HG index because one already exists on the given columns.

Reason for this Error

Only a single HG index of a given type can be created on the same column set. For example, you cannot have two unique HG indexes on the same column set, but you are allowed to have a unique HG and a non-unique HG index on the same set of columns.

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}....