How to drop a constraint?

 Posted by Rajni.Shekhar on 4/17/2012 | Category: Sql Server Interview questions | Views: 1633 | Points: 40
Answer:

using following line of code:

ALTER TABLE <tablename>

DROP CONSTRAINT <constrain name>

Example: There is a table named tblTest and having a constraint "test_Constraint'

ALTER TABLE tblTest
DROP CONSTRAINT test_Constraint


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response