Changing User Defined Data Type | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Changing User Defined Data Type

How can I change the user defined datatype used in my SQL Server? I mean there is always an option of altering the objects in which the user-defined data type has been used and then dropping and creating the datatype again and finally again altering the objects that used the user defined data type. But that is going to be a painfully long process. Is there any other way to do it? Gaurav
Refer to books online for SP_RENAME. _________
Satya SKJ

I guess i didn’t make my question clear. I want to change the data type of the user defined data-type. Say FirstName from Char(15) to Char(20). sp_rename lets me change the name but not the type. Gaurav
I haven’t seen any route to do so, all the times for such change I was deleting and adding the UDD again. _________
Satya SKJ