Error 1000168

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

Item	Description
SQLCode	-1000168L
Constant	EMSG_CANNOT_CREATE_HG
SQLState	QNA35
ODBC 2 State	ERROR
ODBC 3 State	ERROR
Sybase Error Code	20828
Severity Code	14
Parameter 1	type of HG index to be created (non-unique vs. unique)

Probable cause

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.