Error 196

"Index '%1' for table '%2' would not be unique"

Item Description

SQLCode

-196L

Constant

INDEX_NOT_UNIQUE

SQLState

23505

ODBC 2 State

23000

ODBC 3 State

23000

Sybase Error Code

2127

Severity Code

16

Parameter 1

Name of the index that would not be unique.

Parameter 2

Name of the table that contains the index.

Probable cause

You attempted to insert or update a row that has the same value as another row in some column, and there is a constraint that does not allow two rows to have the same value in that column.


Created April 27, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com