How to modify a UNIQUE constraint (Enterprise Manager)

To modify a UNIQUE constraint

  1. Expand a server group; then expand a server.
  2. Expand Databases, expand the database in which the table belongs, and then click Tables.
  3. In the details pane, right-click the table, and then click Design Table.
  4. Right-click the table whose UNIQUE constraint you want to modify; then click Properties.
  5. Click the Indexes/Keys tab.
  6. Click the UNIQUE constraint in the Selected index list.

    If you have selected a UNIQUE constraint, Unique appears in the Type row.

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

See Also
Creating and Modifying UNIQUE Constraints How to modify a UNIQUE constraint using a database diagram

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.