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 |
ganeshkumar08
Posting Yak Master
187 Posts |
Posted - 2009-01-17 : 04:25:55
|
Hi All,Can any one of you help me how to alter the User Defined data type in sql 2000.I need to increase the size of Varchar(15) to Varchar(25)Waiting for your reply.ThanksGaneshSolutions are easy. Understanding the problem, now, that's the hard part |
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-01-17 : 04:34:16
|
try like thisalter table urtablename alter column coulumnname varchar(25) |
|
|
ganeshkumar08
Posting Yak Master
187 Posts |
Posted - 2009-01-17 : 04:36:44
|
Actually i used that UDDT in many tables,SP's and Functions. I need to solution to modify the UDDT.Solutions are easy. Understanding the problem, now, that's the hard part |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|