"Key constraint between temporary tables requires a primary key (not unique constraint)"
| Item |
Description |
|
SQLCode
|
-865L
|
|
Constant
|
INVALID_FOREIGN_KEY_INDEX
|
|
SQLState
|
42R03
|
|
ODBC 2 State
|
42000
|
|
ODBC 3 State
|
42000
|
|
Sybase Error Code
|
2515
|
|
Severity Code
|
16
|
Probable cause
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.