To modify a UNIQUE constraint
If you have selected a UNIQUE constraint, Unique appears in the Type row.
To | Follow these steps |
---|---|
Change the columns that the constraint is attached to. | In the Column name grid, expand the list and click 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. Type 0 to accept the default fill factor. |
Creating and Modifying UNIQUE Constraints | How to modify a UNIQUE constraint using a database diagram |