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 Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
ConKi
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,

ConKi
You are not authorized to post a reply.

Acceptable Use Policy