Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 10.0.1 » SQL Anywhere 10 - Error Messages » Database Error Messages » Alphabetic list of error messages

Primary key for row in table '%1' is referenced by foreign key '%2' in table '%3' Next Page

Primary key for table '%1' is not unique

Item

Value

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.

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.