SQL Server Performance Forum – Threads Archive

User Defined Datatype – Edit

Hi, How do I change the specification of a user defined data type? Assume, I create the following user-defined data type, EXEC sp_addtype fax, ‘varchar(24)’, ‘NULL’ At a latter point of time, we want to change this to varchar(30), is it possible? Thank you. Regards,
Deva

As this is a VARCHAR type anyway, why not create it as VARCHAR(30) right away? —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
Ich unterstuetze PASS Deutschland e.V. http://www.sqlpass.de)

I was enthousiastic about user defined data types, until I found that you cannot use them in stored procedures. Without that, I can’t really see any advantages to using them.

Using user defined datatypes give problems sometimes. It is better not to use them Madhivanan Failing to plan is Planning to fail

What problems? —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
Ich unterstuetze PASS Deutschland e.V. http://www.sqlpass.de)

In EM, it is not possible to change the length or datatypes. Once I designed report based on the table that had user defined datatype. Sometimes I had problems that I could not remember now [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] Madhivanan Failing to plan is Planning to fail

]]>