FK disabling question

• Lexa

  Hall of Fame

  Points: 3314

  More actions

  February 22, 2012 at 9:13 am

  #391619

  Hi All,

  I need to disable some FKs to execute a delete/partition switch. The problem I'm having is that after I re-enable the key, "Check Existing Data On Creation Or Re-Enabling" option is set to "No" after running the code below.

  Can I set that option to Yes without dropping and recreating the key?

  ALTER TABLE mytable NOCHECK CONSTRAINT FK_key

  delete ....

  partition switch

  ALTER TABLE mytable CHECK CONSTRAINT FK_key

  Thanks

• Gazareth

  One Orange Chip

  Points: 27737

  More actions

  February 22, 2012 at 9:36 am

  #1450410

  Hi Lexa,

  Try running ALTER TABLE mytable WITH CHECK CHECK CONSTRAINT FK_key

  More here... http://www.simple-talk.com/sql/database-administration/foreign-keys-and-their-states/

  Cheers

  Gaz

• Lexa

  Hall of Fame

  Points: 3314

  More actions

  February 22, 2012 at 1:42 pm

  #1450546

  Gazareth (2/22/2012)

  ---

  Hi Lexa,

  Try running ALTER TABLE mytable WITH CHECK CHECK CONSTRAINT FK_key

  More here... http://www.simple-talk.com/sql/database-administration/foreign-keys-and-their-states/

  Cheers

  Gaz

  Thanks Gaz