> > 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.

Database Workbench shows you the exact statements it will execute
when you check it's "DDL" tab in the editor.

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

This can be done if there are no references to the column, but not
otherwise.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com