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 |
|
augustin_p
Starting Member
21 Posts |
 Posted - 2002-06-19 : 10:09:36
|
| Hi, I have a default named 'UniqueId' which is bound to various columns. value of the default is 'Right(newid(), 15). Now, i would like to change the value to Right(Newid(), 10). But it says that the default is bound to many columns. Cant i change the value of the default without unbounding the default from the columns.Thanks,prasanna |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2002-06-19 : 11:13:21
|
| No, there is no ALTER DEFAULT statement."A default must be dropped before creating a new one of the same name, and the default must be unbound by executing sp_unbindefault before it is dropped." |
 |
|
|
augustin_p
Starting Member
21 Posts |
Posted - 2002-06-20 : 00:21:38
|
quote:
No, there is no ALTER DEFAULT statement."A default must be dropped before creating a new one of the same name, and the default must be unbound by executing sp_unbindefault before it is dropped."
Hi YellowBug, Thanks for your reply. What if i had bound the default to hundreds of columns? is there no other way.Thanks,prasanna |
|
|
|
|
|
|
Changing values for Default