Hey Gang,

I'm using SQL 2005. There are a couple of sp's that handle adding and removing User-Defined DataTypes:

sp_addtype
sp_droptype

I want some way of updating the types. Does anyone know if that's possible? Here's an example.

Say I have a udt_streetnumber defined as CHAR(6). I already have several tables defined using this udt. Now I realize that 6 isn't big enough and I want to expand it to be CHAR(10). Can I do this?

TIA,
~~Bonnie