How to create or delete a PRIMARY KEY constraint on an existing table (Enterprise Manager)

To create or delete a PRIMARY KEY constraint on an existing table

  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. While holding down the CTRL key, click each column name that comprises the primary key.
  5. Right-click one of the selected column names, then click Set Primary Key.
See Also
Creating and Modifying PRIMARY KEY Constraints How to create or delete a PRIMARY KEY constraint using a database diagram

  


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