Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (L-S)

 

Primary key for table '%1' is not unique : Primary key value ('%2')

Error constant SQLE_PRIMARY_KEY_NOT_UNIQUE
ODBC 2 State 23000
ODBC 3 State 23000
Parameter 1 Name of the table where the problem was detected.
Parameter 2 Duplicate primary key values that caused the error.
Severity 14
SQLCODE –193
SQLSTATE 23W01
Sybase error code 2601
Probable cause

You attempted to add a new row to a table, but the new row has the same primary key as an existing row. The database has not added the incorrect row to the database. For example, you might have added a student with student number 86004 and there is already a row for a student with that number.