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

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

--
18 Jun 2004 08: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,

ConKi


Acceptable Use Policy
---