Alter Table

vaibhav.choksey · Post by **vaibhav.choksey** » Tue Jun 26, 2001 5:28 pm

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

Post by **Kai** » Tue Jun 26, 2001 5:54 pm

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.

bart · Post by **bart** » Wed Jun 27, 2001 8:12 am

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.