1. Home
  2. Computing & Technology
  3. Databases

Creating Tables in Microsoft SQL Server

By , About.com Guide

6 of 7

Select a Primary Key

Setting the Primary Key

Mike Chapple
Next, highlight the column(s) that you've selected for your table's primary key. Then click the key icon in the taskbar to set the primary key. If you have a multivalued primary key, use the CTRL key to highlight multiple rows before clicking the key icon.

Once you've done this, the primary key column(s) will have a key symbol, as shown in the image above.

If you need assistance, you might want to read the article Selecting a Primary Key.
Explore Databases
About.com Special Features

Holiday Central

What to eat, where to go, fun things to do and how to save money on the perfect gifts. More >

Family Tech Center

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

  1. Home
  2. Computing & Technology
  3. Databases
  4. SQL Server
  5. Select a Primary Key for your SQL Server Database Table

©2009 About.com, a part of The New York Times Company.

All rights reserved.