How to disable and Enable the constraints?

 Posted by Sriramnandha on 6/3/2012 | Category: Sql Server Interview questions | Views: 1767 | Points: 40
Answer:

You need to use ALTER TABLE statement to disable constraint.

 alter table <tablename> nocheck constraint <constraintName></CODE]


To Enable

alter table <Tablename> check constraint <constraintName>


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response