"Tables related by key constraint must both be permanent, or both be temporary and not created with ON COMMIT DELETE ROWS. For global temporary tables they must both be shared if one is shared."
| Item |
Description |
|
SQLCode
|
-850L
|
|
Constant
|
INVALID_FOREIGN_KEY_TABLE
|
|
SQLState
|
42R02
|
|
ODBC 2 State
|
42000
|
|
ODBC 3 State
|
42000
|
|
Sybase Error Code
|
2497
|
|
Severity Code
|
16
|
Probable cause
Tables involved in a key constraint relationship must both be permanent user tables or both be temporary tables not created with ON COMMIT DELETE ROWS. Change the definition of one or both tables using ALTER TABLE.