Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Modify Check constraint Expand / Collapse
Author
Message
Posted Monday, February 18, 2008 10:29 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 23, 2008 10:10 PM
Points: 3, Visits: 10
How to modify an check constraint on a table other than dropping and re-creating, can any one help me?
Post #457197
Posted Monday, February 18, 2008 10:37 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, January 30, 2014 8:52 AM
Points: 1,618, Visits: 20,966
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
Post #457199
Posted Monday, February 18, 2008 10:53 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 23, 2008 10:10 PM
Points: 3, Visits: 10
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
Post #457205
Posted Tuesday, February 19, 2008 9:51 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, October 25, 2010 6:09 AM
Points: 1,621, Visits: 409
Hi,
Check out this link
http://technet.microsoft.com/en-us/library/ms179491.aspx

Thanks -- Vj
http://dotnetvj.blogspot.com


Thanks -- Vijaya Kadiyala
www.dotnetvj.com
SQL Server Articles For Beginers



Post #457487
Posted Tuesday, February 26, 2008 12:54 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 26, 2008 12:48 PM
Points: 1, Visits: 0
To modify a CHECK constraint, you must first delete the existing CHECK constraint and then re-create it with the new definition.
Post #460498
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse