Modifying 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.

To modify a unique constraint

1. In your database diagram, right-click the table containing the constraint, then select Properties from the shortcut menu.

   -or-

   Open the Table Designer for the table containing the constraint, right-click in the Table Designer, and choose Properties from the shortcut menu.

2. Choose the Indexes/Keys tab.
   
   
3. Select the constraint you want to change from the Selected index list.
   
   
4. Complete an action from the following table:

   To	Follow these steps
   Change the columns that the constraint is attached to	In the Column name grid, expand the list and select the columns you want to attach the constraint to.
   Rename the constraint	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.
   Set the clustered option	Select the Create as CLUSTERED check box. Only one clustered index can exist per table. If a clustered index already exists, you must first clear this setting on that index.
   Define a fill factor	Type an integer from 0 to 100 in the Fill factor box.

   
   

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

See Also

Constraints | Unique Constraints