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

alter table people add unique (email);