Sybase Error – Foreign keys disallowed on Identity/Autoincrement Columns when set option identity_enforce_uniqueness is on

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.