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