Deferred Constraint Check

• mkg_1232000

  Old Hand

  Points: 307

  More actions

  June 2, 2004 at 1:34 am

  #180373

  Hello

   

  can someone tell me whether sql server 2000 supports the deferred constraint check functionality. If so, how can this be achieved.

   

  Thanks

  Joe

• jordanac

  Hall of Fame

  Points: 3653

  More actions

  June 2, 2004 at 5:59 am

  #508627

  You can use the following statement. You alter the table remove the constraint insert your data and alter the table to add constraint back...

  ALTER TABLE

  WITH NOCHECK

  
  Andy.