Subject RE: [firebird-support] Re: How to update table structure with SQL?
Author Maya Opperman
>From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of neighbour.kerry
>I am almost there. I have almost everything working. My real sticking
point has been the ALTER columns script. Basically, I >think I will just
have to give up on that and hope I will never have to alter a column! It
is probably not a good thing to do on >a live database anyway.

The only thing I have needed to do, is to increase the size of a varchar
field.

That's easy though, just use

alter table alter FieldName type NewType;

As long as your stored procs are all dropped, you have no constraints on
that field, and you are increasing not decreasing the field size it
works wonderfully.