如何把两列都设为主键

[hohai2006]

我的表结构是这样的：
表名：a
结构：id person_id description
我想把id和person-id一起设为主键，请问这个建表语句该怎么写，谢谢！

[hhhdyj]

ALTER TABLE A ADD CONSTRAINT PK_A PRIMARY KEY(id, person_id)

[wgsasd311]

ALTER TABLE A ADD PRIMARY KEY(id, person_id)

[dawugui]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ta]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ta]
GO

CREATE TABLE [dbo].[ta] (
[id] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[person_id] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[description] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL
)
GO

ALTER TABLE ta ADD PRIMARY KEY(id, person_id)

[dawugui]

如果只对ID建立主键

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ta]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ta]
GO

CREATE TABLE [dbo].[ta] (
id char (10) primary key ,
[person_id] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[description] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL
)
GO

[wwh999]

用2楼的得了。

[allright_flash]

手工
1、控制器
2、选择表
3、设计表
4、选择id person_id列
5、加上钥匙状图
6、保存退出
成功。