Error 198

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

Item Description

SQLCode

-198L

Constant

PRIMARY_KEY_VALUE_REF

SQLState

23W05

ODBC 2 State

23000

ODBC 3 State

23000

Sybase Error Code

2129

Severity Code

16

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.

Probable cause

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


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