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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Problem in ALTERING user Defined Data Type

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.

Thanks
Ganesh

Solutions 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 this
alter table urtablename alter column coulumnname varchar(25)
Go to Top of Page

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
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-17 : 06:41:06
see this

http://technet.microsoft.com/en-us/library/ms178136.aspx
Go to Top of Page
   

- Advertisement -