Sybase Error – Key constraint between temporary tables requires a primary key (not unique constraint)

In this blog post, you’ll learn more about the Sybase Error Key constraint between temporary tables requires a primary key (not unique constraint) and the reason for receiving this error

Sybase SQL Error Message

Key constraint between temporary tables requires a primary key (not unique constraint)

Reason for this Error

The key constraint between temporary tables requires a primary key (not a UNIQUE constraint) if the database uses combined indexes. Change the definition of the primary table using ALTER TABLE or rebuild the database.