[firebird-support] Re: FB 3.0, got problem when add field to Table with existing data

[Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]]

02.06.2016 07:42, trsk...@yahoo.com wrote:
>
> I have a table with existing data & got a problem to add field that must
> have a value -> alter table Tbl1 add Fld1 int not null.

What value must it have? Add a default clause to this statement. Or add 
the field as nullable, populate with data and then alter to NOT NULL.


Dmitry