InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 00:37:51 GMT20http://www.sqlservercentral.com/Forums/Topic457197-169-1.aspxTo modify a CHECK constraint, you must first delete the existing CHECK constraint and then re-create it with the new definition.Tue, 26 Feb 2008 12:54:45 GMTmarwa_sisohttp://www.sqlservercentral.com/Forums/Topic457197-169-1.aspxHi,Check out this linkhttp://technet.microsoft.com/en-us/library/ms179491.aspxThanks -- Vjhttp://dotnetvj.blogspot.comTue, 19 Feb 2008 09:51:55 GMTVijaya Kadiyalahttp://www.sqlservercentral.com/Forums/Topic457197-169-1.aspxsorry,i can't able to open the follwing linkmk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\vdtsql.chm::/dvhowmodifyingcheckconstraint.htmMon, 18 Feb 2008 22:53:05 GMTttparavindhhttp://www.sqlservercentral.com/Forums/Topic457197-169-1.aspxSee the below link in BOL for more information.mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\vdtsql.chm::/dvhowmodifyingcheckconstraint.htmMon, 18 Feb 2008 22:37:41 GMTAdigahttp://www.sqlservercentral.com/Forums/Topic457197-169-1.aspxHow to modify an check constraint on a table other than dropping and re-creating, can any one help me?Mon, 18 Feb 2008 22:29:50 GMTttparavindh