CODE EXAMPLE FOR SQL

SQL Server Altering Column to be Unique

alter table location_key drop constraint pinky;
alter table your_table add constraint pinky unique(yourcolumn);