Error 1000165

Message text

Only a single foreign key constraint can be created on the same foreign key column(s) and same candidate key column(s).

Item

Value

SQLCode

-1000165

Constant

EMSG_SINGLE_FKEY_CONSTRAINT

SQLState

QNA34

ODBC State

ERROR

Probable cause

For a given set of foreign key columns and candidate key columns, you can only create a single foreign key constraint on the same foreign key column(s) and same candidate key column(s).