Share via


Unique Constraints (Visual Database Tools)

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 Table Designer, you use the Indexes/Keys dialog box to create, modify, or delete unique constraints.

For information about

See

Ensuring no duplicate values are entered in specific columns

How to: Create Unique Constraints

Changing the columns that the constraint is attached to, changing the constraint name, or setting additional properties for the constraint

How to: Modify Unique Constraints

Removing the requirement for uniqueness for values entered in the column

How to: Delete Unique Constraints

See Also

Reference

Indexes/Keys Dialog Box

Other Resources

Working with Constraints

Working with Relationships