Subject Re: [firebird-support] Changing column type
Author Martijn Tonies
Hello Rick, Milan,

> DBW updates, as far as I can tell, using standard DDL. It was what I
> was using when I got the error.
> I was hoping to avoid the massive recreate :-)

Indeed, Database Workbench only uses standard DDL to update
column types. Doing otherwise might result in data-loss errors.

Rick, in your case, I suggest adding two new columns, one with
the right type and one with the current same type. Transfer the
data. Update RDB$DEPENDENCIES to point to the new column
of the same type. Drop the old column. Rename the new column
with the new type to have the old name, update
RDB$DEPENDENCIES again to hold the old name and drop
the dummy column.

Of course, all after a backup :-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions