Question:
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.
Answer:
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.
