If we have a table people with a column email and we want to make it non-nullable after we have already added it to table:

alter table people alter column email set not null;