Sybase Error – LOAD TABLE not allowed on temporary table which has foreign key references from another table

In this blog post, you’ll learn more about the Sybase Error LOAD TABLE not allowed on temporary table which has foreign key references from another table and the reason for receiving this error

Sybase SQL Error Message

LOAD TABLE not allowed on temporary table which has foreign key references from another table

Reason for this Error

The LOAD TABLE statement removes all rows in a temporary table upon failure. If a temporary table being loaded caused an error then the foreign rows would be orphaned.