Error 1008029

"Cannot create foreign key to an unenforced primary key or unenforced unique constraint."

Item Description

SQLCode

-1008029L

Constant

EMSG_NOFKEY_TO_UNENFORCED

SQLState

QNA29

ODBC 2 State

ERROR

ODBC 3 State

ERROR

Sybase Error Code

21059

Severity Code

14

Probable cause

Existing unenforced primary keys or unique constraints cannot be used to create an referential integrity relationship to a foreign table.


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