Hi all, I need to change a column length.
>From varchar(150) to varchar(250). It's easy to change with an ALTER command? Or I need to create a new column, copy all data from the old column to the new one, then drop the old and rename the new. If only exists the second solutions, the new column it will be created last one of the columns, then I must change all INSERT and UPDATE commands in my application. It's possible to create a column in a given position in the columns structure of a table?. Thanks in advance. -- Marc Soler ---------------------------(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
