How to create a PRIMARY KEY constraint when creating a table (Enterprise Manager)

To create a PRIMARY KEY constraint when creating a table

  1. Expand a server group; then expand a server.
  2. Expand Databases; then expand the database in which to create the table.
  3. Right-click Tables; then click New Table....
  4. In the Choose Name dialog box, enter a name for the table.
  5. Fill in the columns as appropriate. Each row represents one column in the table.
  6. While holding down the CTRL key, click the column names that comprise the primary key.
  7. Right-click one of the selected column names; then click Set Primary Key.
See Also

Creating and Modifying PRIMARY KEY Constraints

  


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