How to modify a PRIMARY KEY constraint (Enterprise Manager)

To modify a PRIMARY KEY 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 any column; then click Properties.
  5. Click the Indexes/Keys tab.
  6. Click the primary key index in the Selected index list.
  7. Complete an action from the following table.
To Follow these steps
Change the column order within a composite primary key In the Column name grid, expand the list of columns and select the column that you want to order first in the primary key. Repeat this step in subsequent rows of the Column name grid to reorder the remaining columns in the primary key.

 

 

Note Each column name must be unique in a primary key. If you select the same column name in more than one row of the Column name grid, an error will prevent you from saving the table.

 
Rename the primary key 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 this option is not available for your index, you must first clear this setting on the existing clustered 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 PRIMARY KEY Constraints  

  


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