Modify a Unique Constraint

Modify a unique constraint when you want to change the columns that the constraint is attached to, change the constraint name, or set additional properties for the constraint.

1. In the Database window, click Database Diagrams   under Objects, click the database diagram you want to open, and then click Design on the Database window toolbar.
2. In your database diagram, right-click the table containing the constraint, then select Indexes/Keys from the shortcut menu.
3. Select the constraint you want to change from the Selected index list.
4. Type a new name in the Index name box. Make sure that your new name does not duplicate a name in the Selected index list.

The constraint is updated in the database when you save your database diagram.