Error 1000186

Message text

Cannot create foreign key constraint on a candidate key that is also a foreign key.

Item

Value

SQLCode

-1000186

Constant

EMSG_CKEY_IS_ALSO_FKEY

SQLState

QNA40

ODBC State

ERROR

Probable cause

A candidate key cannot also be a foreign key.