You can use the ALTER table statement. Check the manual for more info.
Michael
Krzysztof Jedon wrote:
> I have only one SQL question.
> How can I change the type of one column
> in an existing table without much work with it... :-)
>
> An example:
> change a type of one column from smallint
> in mediumint.
>
> Any advice? Thanks for your help.
>
> jed
>
> ---------------------------------------------------------------------
> To request this thread, e-mail win32-thread33@stripped
> To unsubscribe, e-mail the address shown in the
> List-Unsubscribe header of this message.
> For additional commands, e-mail: win32-help@stripped