how to change user-defined datatype in 6.5. Help!!

Last Post 18 Jun 2004 07:10 AM by ConKi. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

18 Jun 2004 07:10 AM
Greeting All,
I need to change the size of a user-defined datatype from char(10) to char(20). Doing that, I have to somehow change the datatype of the column that is currently using the UDT to something else so that I could drop the UDT and recreate it with new size.
6.5 does not offer alter column command. I have to drop the table then I can be able to drop the UDT. Obviously, I do not want to do that because the number of table to drop is huge.
Is there any work around in 6.5 that solve this problem?

Thank you,


Acceptable Use Policy