| Subject | Re: FB 3.0, got problem when add field to Table with existing data |
|---|---|
| Author | Dmitry Yemanov |
| Post date | 2016-06-02T04:56:34Z |
02.06.2016 07:42, trskopo@... wrote:
the field as nullable, populate with data and then alter to NOT NULL.
Dmitry
>What value must it have? Add a default clause to this statement. Or add
> 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.
the field as nullable, populate with data and then alter to NOT NULL.
Dmitry