Subject | Re: [firebird-support] Change field type |
---|---|
Author | Carlos Tré |
Post date | 2006-09-08T10:02:26Z |
Hello Rick,
Thursday, September 7, 2006, 9:02:17 AM, you wrote:
--
HTH,
Carlos
[Non-text portions of this message have been removed]
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]