How to disable and Enable the constraints?

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

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