Referential integrity actions other than RESTRICT not allowed for temporary tables
Item
Value
SQLCODE
-849
Constant
SQLE_INVALID_FOREIGN_KEY_ACTION
SQLSTATE
42R01
Sybase error code
1709
ODBC 2 State
42000
ODBC 3 State
42000
Probable cause
You attempted to specify an unsupported referential integrity action for a temporary table.