Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Aug 10, 1999

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

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

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date