Subject | RE: [firebird-support] Re: How to update table structure with SQL? |
---|---|
Author | Maya Opperman |
Post date | 2009-06-23T12:38:59Z |
>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 stickingpoint 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.