"Cannot create unique HG index because primary key or unique constraint already exists on the given columns."
Item | Description |
---|---|
SQLCode |
-1000169L |
Constant |
EMSG_CANNOT_CREATE_UNIQUE_HG |
SQLState |
QNA36 |
ODBC 2 State |
ERROR |
ODBC 3 State |
ERROR |
Sybase Error Code |
20829 |
Severity Code |
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.