>
> This cannot be done with standard DDL, you can use Database
> Workbench to do it though :-)
>
>

However all our updates happen automatically without any tool.
I was able to do this with the help of 'The Firebird Book' of Helens,
and also what Adam posted about getting current default values.

Would have been nicer to somehow have that magic which you use is your
program but beggars can't be choosers.

I created a new column and moved the data, dropped the current column
and replaced with a new column.

Kind Regards,

Robert.