the generated SQL ist similar to ALTER TABLE theTable ADD DEFAULT 'the default' FOR theColumn; .
the SQL that would work (in Access 2003):
ALTER TABLE theTable ALTER COLUMN theColumn SET DEFAULT "the default";
The command used:
dotnet ef database update