Alter Nonmaterialized Columns

Use alter table .... replace to changed the defaults of nonmaterialized columns. However, this command does not change the defaults for columns using the previous default. Instead, alter table .... replace changes the defaults for columns that you add or update.