Changing a User Defined Type from char(5) to varchar(15)

[nandamurisrihari]

Hi ALL

Regarding the User Defined Data Types,iam facing problem while changing from char(5) to varchar(15).
Could you please help me out regarding this.
Problem changed UDT from char(5) to varchar(15) in SYSTYPES table.But it doesnt change the datatype of the columns that were defined based on the UDT. Obviously, although the column remains bound to the UDT, the resulting definition, i.e. char(5), is used in the table definition .

Is there any procedure to alter the UDT
Please suggest me regarding this
Regards
srihari

 

[nigelrivett]

I'm afraid the udt is only used for object creation - objects are not changed when the udt is changed.

Have a look at

http://www.nigelrivett.net/AlterTableProblems.html

To see what would be involved if it did update al objects.

To make the changes look at INFORMATION_SCHEMA.COLUMN_DOMAIN_USAGE to see where udt's are used.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.