主键设置

在创建表的时候创建主键：

USE Accounting;

CREATE TABLE Customers
(
   CustomerNo     int   IDENTITY   NOT NULL
      PRIMARY KEY,
   CustomerName   varchar(30)      NOT NULL,
   Address1       varchar(30)      NOT NULL,
   Address2       varchar(30)      NOT NULL,
   City           varchar(20)      NOT NULL,
   State          char(2)          NOT NULL,
   Zip            varchar(10)      NOT NULL,
   Contact        varchar(25)      NOT NULL,
   Phone          char(15)         NOT NULL,
   FedIDNo        varchar(9)       NOT NULL,
   DateInSystem   smalldatetime    NOT NULL
);

在已存在的表上创建主键：

USE Accounting

ALTER TABLE Employees
   ADD CONSTRAINT PK_EmployeeID
   PRIMARY KEY (EmployeeID);