Subject Re: [firebird-support] Re: Changing column default values
Author Martijn Tonies
> > 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

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
My thoughts:
Database development questions? Check the forum!