关于主码的问题

[cockroachzl]

如果主码是（name,age,sex)那么是不是 只要这3个属性只要有1个不同就可以存在呢
例如（aaa,25,male)和（bbb,25,male)是不是可以同时存在在这个表中？
还有创建这个表的 SQL语句怎么写呢？primary key只能声明一个属性是主码啊！

谢谢了！

[rivery]

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

CREATE TABLE [dbo].[test] (
[a] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[b] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[c] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[d] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[test] ADD
CONSTRAINT [PK_test] PRIMARY KEY CLUSTERED
(
[a],
[b]
) ON [PRIMARY]
GO

[iwl]

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

CREATE TABLE [dbo].[test] (
[a] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[b] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[c] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[d] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[test] ADD
CONSTRAINT [PK_test] PRIMARY KEY CLUSTERED
(
[a],
[b]
) ON [PRIMARY]
GO

或者可以在表的设计模板里面同时选中这三列就可以了

[cockroachzl]

谢谢，结贴了