February 18, 2008 at 10:29 pm
How to modify an check constraint on a table other than dropping and re-creating, can any one help me?
February 18, 2008 at 10:37 pm
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
February 18, 2008 at 10:53 pm
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
February 19, 2008 at 9:51 am
Hi,
Check out this link
http://technet.microsoft.com/en-us/library/ms179491.aspx
Thanks -- Vj
February 26, 2008 at 12:54 pm
To modify a CHECK constraint, you must first delete the existing CHECK constraint and then re-create it with the new definition.
March 27, 2017 at 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
March 29, 2017 at 1:02 pm
HelgaK - Monday, March 27, 2017 3:42 PMI 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
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply