On Thu, 2002-12-12 at 14:50, Robert Treat wrote: > On Thu, 2002-12-12 at 01:39, Mukund Pate wrote: > > hello, > > > > how to modify the datatype of column in a table? > > > > i have created table with one coulmn datatype is varchar(200) so i > > would like to change to text datatype > > > > You will need to recreate the table. > > Robert Treat
Actually, I should point out that you can do an alter table add col2 text, update table set col2 = col1, update col1 set = NULL, rename col1 coldepricated, rename col2 to col1. If your in 7.3 you can drop coldepricated too. Sorry for the weak answer before. Robert Treat ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly