Subject Re: [firebird-support] Change field type
Author Carlos Tré
Hello Rick,

Thursday, September 7, 2006, 9:02:17 AM, you wrote:

> FB 1.5.3
> I made a mistake when I originally designed a table column and
> specified "Smallint" rather than "Integer".
> Now its coming back to haunt me and I have to change it to Integer.
[...]
> Is there some easier way to do this?


Well, Rick, I had a smilar problem just the other day, and I as I could afford to bring the database (50MB) offline for a while I made a combined metadata and data extract (ibexpert does this nicely), changed the result script where I nedeed and then rebuilt the database.

--
HTH,
Carlos

[Non-text portions of this message have been removed]