A unique constraint ensures no duplicate values are entered into specified columns that are not a tableÆs primary key. For example, in the employee table in which the emp_id column is the primary key, you can define a unique constraint that requires entries in the Social Security number (ssn) column to be unique within the table.
In database diagrams, you use the Indexes/Keys property page to create, modify, or delete unique constraints.