I have to do bulk card inserts/updates/removes on the table-by-table basis via JDBC. Database is Sybase.

Due to FK inspections, I can not do that, because I temporarily violate integrity.

In MySQL I'm able to easily turn on / off constraint inspections, by giving an easy command.

Can there be some method of doing exactly the same in Sybase?


It's standard where Sometimes to interrupt in the DDL into Table, Constraints, after which Indexes each element only calling CREATE when the object did not exist. You can produce a saved method that drops key constraints, after which simply run the DDL once you are completed with your bulk place/update/remove.