Subject Re: [firebird-support] Update Table
Author Milan Babuskov
Marcelo Machado wrote:
> Thank you ann, will try backup an restore the table.

You can only backup/restore entire database not one table.

> The same is still empty.
> But I still need to insert 400 fields more or less!
>
> Will it be possible?

If you "insert" by running "alter table add..." one by one, then you're
going to hit 255 changes limit again.

> (Or will it be better to already create a new table with the 600 fields?)

It would be better. Or, you can run a big ALTER TABLE statement to add
all fields at once (after backup/restore of course).

I'm curious, why do you need a 600-fields table? It doesn't seem right.

--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org