SQL Server2008如何设置主键

[zpfuyao]

我想把某一列设置为主键请问如何编写代码或者如何进行操作，请给出详细过程

[-晴天]

ALTER TABLE dbo.tb ADD CONSTRAINT
	PK_tb PRIMARY KEY CLUSTERED 
	(
	id
	)

[Kshatriya]

ALTER TABLE [dbo].[Dept] ADD CONSTRAINT [PK_Dept] PRIMARY KEY CLUSTERED
(
[DeptNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

[geniuswjt]

够详细么

[q465897859]

-----将字段设为主键或联合主键
alter table tt add  constraint PK_id primary key(id)
alter table tt add constraint pk_id_cid primary key(id,cid)