Disable Foreign key constraint on a table?

Question

Can i temporarily disable a foreign key constraint. How do i do this?

Check also this related question: Can foreign key constraints be temporarily disabled using TSQL? — kristof
– kristof, Commented Apr 8, 2009 at 7:58

Chris Shaffer · Accepted Answer · 2009-04-08 01:59:15Z

25

To temporarily disable a constraint (foreign keys are constraints):

ALTER TABLE MyTable NOCHECK CONSTRAINT MyConstraint

To re-enable a constraint

ALTER TABLE MyTable CHECK CONSTRAINT MyConstraint

answered Apr 8, 2009 at 1:59

Chris Shaffer

32.6k5 gold badges52 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ojblass Over a year ago

be warned this will fail if your data is not referntially in tact.

Andy Jones · Accepted Answer · 2009-04-08 12:53:11Z

1

Incidentally, this is why you need "Alter table" permissions when you BCP or Bulk Insert data into a table. Using the default configuration, check constraints and foreign keys are not checked.

answered Apr 8, 2009 at 12:53

Andy Jones

1,48210 silver badges16 bronze badges

Collectives™ on Stack Overflow

Disable Foreign key constraint on a table?

2 Answers 2

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Linked

Related