iAnywhere.com - Tables related by key constraint must both be permanent, or both be temporary and not created with ON COMMIT DELETE ROWS

Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Error Messages » Database Error Messages » Alphabetic list of error messages

Tables related by key constraint must both be permanent, or both be temporary and not created with ON COMMIT DELETE ROWS

Item	Value
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.