How do I temporarily disable foreign keys in a table, insert more rows, and then enable them again?
In particular, I need to know about syntax and what the code would be like.
You need to disable the mechanism that enforces integrity, the CONSTRAINT against the column housing the foreign key. You do this by using the ALTER TABLE command like this:
ALTER TABLE MyTable DROP CONSTRAINT MyConstraintName
To re-enable the constraint after the operation, ALTER the table again. The particular syntax depends on what you are trying to re-establish; it’s different for PRIMARY KEY, FOREIGN KEY, and DEFAULT—not to mention the different flavors of indexes, etc.
Take a look in Books On Line for examples of the particular constraint need.