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?