SQL Server Performance Forum – Threads Archive

user defined data types

hello,
Is it possible to modify user defined data types, once they been created?
If yes can someone provide me with some help. thanks.

I dont think so
You need to use real datatypes than that Madhivanan Failing to plan is Planning to fail

Yes, but here’s what I’m trying to do,
I have a lookup table which is referenced in many other tables, I thought to make a uddt which is going to be primary key for this lookup table and use it in all other tables where are referencing this table, so then if I try to modify for instance the length of this field in primary key table, I do not have to go in all other tables one by one to modify it, you know what I mean.
Ok what can we do, but another good think is that by using this method you can easy find the list of objects that use this uddt, so then you know where you have to make the modifications.

]]>