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 |
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).