Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
paritosh
Starting Member
42 Posts |
 Posted - 2011-10-13 : 05:25:45
|
| HOW TO DROP DEFAULT CONTRAINT IN SQL SERVERGIVE EXAMPLE |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-10-13 : 05:48:41
|
http://www.w3schools.com/sql/sql_default.aspand please don't shout ...
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
paritosh
Starting Member
42 Posts |
Posted - 2011-10-14 : 01:29:19
|
| hi webfred,this url of w3school is not working on sql server 2005.this give error so how can i solve this problem .i you have any other solution so pls give a best way . |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-10-14 : 04:21:17
|
In SSMS right click on the constraint there you can choose to script a drop constraint and then you will have your example.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
drop default constraint