unique constraint

Once you establish a unique constraint, every value in the named columns must be unique. If you go to update or insert a row with a value that already exists in a column with a unique constraint, SQL Server will raise an error and reject the record.

create table employee
{
empid int unique,
empname varchar(20),
empLname varchar(20),
}

see more information from visit