Thunderstone Support Forums

Hi!
I have created table search of
ID integer, NAME varchar(2000)
But Now I want to alter this table with
NAME varchar(4000). The way I am doing it is
ALTER TABLE search MODIFY NAME varchar(4000)
But gives me error message: Syntex error at TABLE.

I double checked my table name and it's correct.
So I was wodering if you can help me with the syntex.
thanks

Altering a table is not currently supported in Texis; you would have to re-create the table with the new schema. However, it is not necessary to change the size of a varchar field in Texis, as any varchar field can store any size string (up to 1GB) with no loss of data or wasted space, regardless of declared size.

There's probably no need for you to do an Alter in this instance. Texis will auto-size varchar fields, so changing your Name field from varchar(2000) to varchar(4000) will probably not have any effect.

One handy thing to remember is the "create table B as select x,y,z, from A" command. It does not apply to your situation, but is useful in related matters.