Error 193

Message text

Primary key for table '%1' is not unique

Item

Value

SQLCode

-193

Constant

SQLE_PRIMARY_KEY_NOT_UNIQUE

SQLState

23W01

ODBC State

23000

Parameter 1

name of the table where the problem was detected

Probable cause

You have tried to add a new row to a table where 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.