Use a unique constraint to ensure that no two rows have the same values in the columns of the constraint.
- Select , then choose one of the following:
- Select the table for the unique constraint.
- Select Properties.
- Select .
You see the Add Unique Constraint wizard.
- Specify a name, then select Unique constraint.
- (Optional) Click Make supporting index clustered.
- Select the columns to include in the unique constraint.
- Select a segment on which to place the unique constraint.
- (Optional) Specify a fill factor percentage.
- (Optional) Specify the maximum number of rows per page for the index.
- (Optional) Specify the ratio of empty pages to filled pages to provide for expansion.
- (Optional) Click Summary to verify your selected options.