[firebird-support] Alter column not null with constraint name FB3

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

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