Error 193

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

Item Description

SQLCode

-193L

Constant

PRIMARY_KEY_NOT_UNIQUE

SQLState

23W01

ODBC 2 State

23000

ODBC 3 State

23000

Sybase Error Code

2124

Severity Code

14

Parameter 1

Name of the table where the problem was detected.

Parameter 2

Duplicate primary key values that caused the error.

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.


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