add FK constraint with nocheck

From: Norman (anonymous_at_discussions.microsoft.com)
Date: 03/17/04 

Date: Wed, 17 Mar 2004 01:10:12 -0800

I want to drop FK constraints while I do mass delete from
tables which has several steps relationships.
And then when deletions are done I have to set back.
In the tables even after the deletion there are over 300
million posts.
So, I want to add FK constraints with nocheck so that SQL
server doesn't check existing data.
But what happens when new data is added ?
Do these FK constraints added as with nocheck will check
the PK in parent tables ?
 Anyone know how "add FK constraint with nocheck" exactly
works ?

Relevant Pages

  • Re: add FK constraint with nocheck
    ... >Nocheck will ignore what is existing in your tables, ... >> I want to drop FK constraints while I do mass delete ... >> And then when deletions are done I have to set back. ... >> the PK in parent tables? ...
    (microsoft.public.sqlserver.mseq)
  • Re: add FK constraint with nocheck
    ... Nocheck will ignore what is existing in your tables, ... "Norman" wrote in message ... > And then when deletions are done I have to set back. ... I want to add FK constraints with nocheck so that SQL ...
    (microsoft.public.sqlserver.mseq)
  • Re: Delete query taking long time to execute
    ... I have asked him to do the NOCHECK when the system is offline (No users ... constraints [See ALTER TABLE WITH NOCHECK] to make the DELETE faster. ...
    (microsoft.public.sqlserver.mseq)
  • Re: negative mass in modelling constraints
    ... TEST mass m1 than all the mass of m1, ... > The natural frequencies of an object depend on constraints such as the ... The natural frequencies and vibration modes of the ...
    (sci.engr.mech)
  • Re: TSQL - Alter table to add a clustered prime key index
    ... You can not have two constraints in a single definition (Check and Primary ... Wayne Snyder, MCDBA, SQL Server MVP ... > ALTER TABLE USERS WITH NOCHECK ADD CONSTRAINT PK_USERS CHECK USERCODE ...
    (microsoft.public.sqlserver.programming)