|Subject||Re: [firebird-support] Re: Changing column default values|
> > This cannot be done with standard DDL, you can use DatabaseDatabase Workbench shows you the exact statements it will execute
> > 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.
when you check it's "DDL" tab in the editor.
> I created a new column and moved the data, dropped the current columnThis can be done if there are no references to the column, but not
> and replaced with a new column.
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Database development questions? Check the forum!