It depends if you want to keep the existing data in that field?

You have to get quite proficient at SQL for this sort of thing.

I prefer to create a new database with the correct names and details,
then use <Pump> from IB_WISQL to move over the data. You can correct the
destination=source entries to reflect the name change, and then stream
over all the data.

The alternative is to drop the primary key, create a new column, copy
old column to new column, delete old column, recreate primary key. This
leaves the new column at the end of the table, which is why I prefer
Pump.

Does any of the management tools do a better job for this sort of
'problem'?

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services