"Foreign keys disallowed on Identity/Autoincrement Columns when set option identity_enforce_uniqueness is on"
| Item |
Description |
|
SQLCode
|
-1008032L
|
|
Constant
|
EMSG_FOREIGN_KEY_DISALLOWED
|
|
SQLState
|
QNA41
|
|
ODBC 2 State
|
ERROR
|
|
ODBC 3 State
|
ERROR
|
|
Sybase Error Code
|
20026
|
|
Severity Code
|
14
|
Probable cause
An Identity/Autoincrement Column cannot be a foreign key when the set option identity_enforce_uniqueness is on. Either turn the option off, or chose a different column for the foreign key.