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 |
|
sent_sara
Constraint Violating Yak Guru
377 Posts |
 Posted - 2007-03-21 : 11:57:12
|
| hi fys,I have created a user defined datatype using the following commandssp_addtype 'balance_qty','int','null'it was successfully createdjust now i want to modity the datatype to numeric(28,3).if make a dropsp_droptype 'balance_qty' it throws a error:Cannot drop type 'balance_qty' because it is currently in use.can u pls suggest how to ovecome the above solution:i need balance_qty numeric(28,2) |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
how to alter sp_addtype