| Subject | Alter column not null with constraint name FB3 |
|---|---|
| Author | liviuslivius |
| Post date | 2018-04-24T07:34Z |
Hi,
I need to add Field not null constraint with my custom name.
in previous versions of Firebird we can do:
1. ALTER TABLE XXX ADD FIELDX INTEGER CONSTRAINT NK_XXX__FIELDX NOT NULL;
2. UPDATE TABLE XXX SET FIELDX=some calculations;
Now in Firebird 3 this is prohibited on table with data.
Then i do this on FB3.
1. ALTER TABLE XXX ADD FIELDX INTEGER;
2. UPDATE TABLE XXX SET FIELDX=some calculations;
3. Add not null - how? I see only ALTER TABLE XXX ALTER FIELDX SET NOT NULL; there are not place for constraint name
i need to add Field not null constraint with my custom name.
regards,
Karol Bieniaszewski