Error 1226

"Foreign key columns do not match the primary key or a uniqueness constraint in \"%1\No message

Item Description

SQLCode

-1226L

Constant

NO_MATCHING_INDEX

SQLState

42R04

ODBC 2 State

ERROR

ODBC 3 State

ERROR

Sybase Error Code

2904

Severity Code

16

Parameter 1

The name of the primary table.

Probable cause

An attempt was made to create a foreign key, but the columns specified do not match the primary key or a uniqueness constraint for the referenced table.


Created May 6, 2011. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com