Disabling FK constraints until the end of a txn

Is there any way to disable the foreign key constraints on a table until the end of a transaction?

I remember working with a db (can't remember the brand, maybe it was sybase or mssql) where i could defer the constraint checking until the transaction was committed. This way the sequence of inserts didn't matter.

Thanks for your help.

Ralf Kretzschmar Received on Fri Feb 05 1999 - 03:40:07 CST