Modify Check constraint

  • ttparavindh

    Old Hand

    Points: 303

    How to modify an check constraint on a table other than dropping and re-creating, can any one help me?

  • Adiga

    One Orange Chip

    Points: 27224

    See the below link in BOL for more information.

    mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\vdtsql.chm::/dvhowmodifyingcheckconstraint.htm

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • ttparavindh

    Old Hand

    Points: 303

    sorry,i can't able to open the follwing link

    mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\vdtsql.chm::/dvhowmodifyingcheckconstraint.htm

  • Vijaya Kadiyala

    SSCrazy Eights

    Points: 9119

    Hi,

    Check out this link

    http://technet.microsoft.com/en-us/library/ms179491.aspx

    Thanks -- Vj

    http://dotnetvj.blogspot.com

  • marwa_siso

    Valued Member

    Points: 63

    To modify a CHECK constraint, you must first delete the existing CHECK constraint and then re-create it with the new definition.

  • HelgaK

    SSC Enthusiast

    Points: 169

    I recently read an article CHECK constraints in SQl Server http://codingsight.com/check-constraints-in-sql-server/ . may be it could be helpful for you too

  • drew.allen

    SSC Guru

    Points: 76409

    HelgaK - Monday, March 27, 2017 3:42 PM

    I recently read an article CHECK constraints in SQl Server http://codingsight.com/check-constraints-in-sql-server/ . may be it could be helpful for you too

    First, that article doesn't answer the original question.

    Second, this thread is over nine years old and the original poster has had no activity in those nine years.  You want to be very careful about responding to old threads.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA


    How to post data/code on a forum to get the best help[/url].How to Post Performance Problems[/url]

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply