devxlogo

Foreign Keys

Foreign Keys

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&#151not to mention the different flavors of indexes, etc.

Take a look in Books On Line for examples of the particular constraint need.

devx-admin

Share the Post: