Collection Contents Index Primary key column '%1' already defined Next PDF

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'

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.

Collection Contents Index Primary key column '%1' already defined Next PDF