How to disable and Enable the constraints?

Posted by Sriramnandha on 6/3/2012 | Category: Sql Server Interview questions | Views: 3035 | 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

Bookmark It

< Previous : Can you drop a Parent Table with out affecting its ...

Next > : Difference between Primary key,unique key,Alternat ...

More Interview Questions by Sriramnandha

Latest Interview Questions