In this blog post, you’ll learn more about the Sybase Error Cannot create unique HG index because primary key or unique constraint already exists on the given columns. and the reason for receiving this error
Sybase SQL Error Message
Cannot create unique HG index because primary key or unique constraint already exists on the given columns.
Reason for this Error
When you create a primary key or unique constraint, IQ automatically creates a unique HG index as the mechanism for enforcing the ‘uniqueness’ attribute of a primary key or unique constraint. Consequently, a user cannot create another unique HG on the same columns on which the primary key or unique constraint is defined.
