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

Error constant SQLE_INVALID_FOREIGN_KEY_TABLE
ODBC 2 State 42000
ODBC 3 State 42000
Severity 16
SQLCODE –850
SQLSTATE 42R02
Sybase error code 1709
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.

Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1