In this blog post, you’ll learn more about the Sybase Error Foreign keys disallowed on Identity/Autoincrement Columns when set option identity_enforce_uniqueness is on and the reason for receiving this error
Sybase SQL Error Message
Foreign keys disallowed on Identity/Autoincrement Columns when set option identity_enforce_uniqueness is on
Reason for this Error
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.
