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 |
|
xpandre
Posting Yak Master
212 Posts |
 Posted - 2009-01-07 : 03:37:29
|
| Hi,I need to change the defualt value of a column from , say 1 to 2.Can I do it in 1 DDL or do I have to drop the existing constraint and re-create it?ThanksSam |
|
|
raky
Aged Yak Warrior
767 Posts |
Posted - 2009-01-07 : 04:06:11
|
| I think dropping the existing constraint and re-creating it is the only way... |
 |
|
|
xpandre
Posting Yak Master
212 Posts |
Posted - 2009-01-07 : 04:18:35
|
| Yes..I think so too..Thanks:-) |
|
|
|
raky
Aged Yak Warrior
767 Posts |
Posted - 2009-01-07 : 05:26:35
|
| Welcome.... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
xpandre
Posting Yak Master
212 Posts |
Posted - 2009-01-07 : 10:56:15
|
| Thanks Visakh :-) |
|
|
|
|
|
|
Change the default value of a column