In this blog post, you’ll learn more about the Sybase Error The specified foreign key (%1) cannot be enforced and the reason for receiving this error
Sybase SQL Error Message
The specified foreign key (%1) cannot be enforced
Reason for this Error
You attempted to create a foreign key that cannot be enforced. To be enforceable, the primary and foreign table for the specified key must exist on the same server. You can use the UNENFORCED keyword to create a foreign key specification that is not to be enforced.