--- In IBObjects@yahoogroups.com, "mlc29150" <mlc29150@y...> wrote:

> Hello,
>
> I've got a small problem :
>
> I want to upgrade a Firebird database structure (change the size of

a

> column: from 10 char to 13 char length)...
> For this I've tried a similar SQL instruction as we can write with
> Oracle...but this doesn't works...
>
> SQL > ALTER TABLE MYFBTABLE MODIFY (NAMEFIELD CHAR(13) NULL)
>
> It's seem that the error is the MODIFY instruction...
>
> Does someone known how to do this with the very good FireBird,

please?

>
> Thank you ...
> Michel
> (I'm using Delphi 7, IBO 4.3 and FB1.03...will change for FIB 1.5

in

> near days...)

This question should be asked in the Firebird support group but in
Interbase this will work:

ALTER TABLE MYFBTABLE ALTER NAMEFIELD TYPE CHAR(13)

Note that the statement will fail if the field is referenced in
another object (such as a stored procedure).