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 column '%1' already defined Next Page

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


Item

Value

Constant

SQLE_PRIMARY_KEY_VALUE_REF

ODBC 2 State

23000

ODBC 3 State

23000

Parameter 1

The name of the table containing the row being modified.

Parameter 2

The name of the foreign index (or role) of the referencing table.

Parameter 3

The name of the foreign table referencing the primary row.

Severity

16

SQLCODE

-198

SQLSTATE

23W05

Sybase error code

547

Probable cause

You attempted to delete or modify a row whose primary key value is referenced elsewhere in the database.