if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PEFY01]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[PEFY01]
GOCREATE TABLE [dbo].[PEFY01] (
[a] [char] (13) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[b] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[c] [char] (3) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[EFY_SALE_R] [numeric](38, 3) NULL ,
[EFY_SALE_RS] [numeric](38, 3) NULL ,
[EFY_OPERATETIME] [datetime] NULL
) ON [PRIMARY]
GO
drop table [dbo].[PEFY01]
GOCREATE TABLE [dbo].[PEFY01] (
[a] [char] (13) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[b] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[c] [char] (3) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[EFY_SALE_R] [numeric](38, 3) NULL ,
[EFY_SALE_RS] [numeric](38, 3) NULL ,
[EFY_OPERATETIME] [datetime] NULL
) ON [PRIMARY]
GO
[a] [int] NOT NULL ,
[b] [int] NOT NULL ,
[c] [int] NULL
)
GOALTER TABLE [dbo].[T_1] WITH NOCHECK ADD
CONSTRAINT [PK_T_1] PRIMARY KEY CLUSTERED
(
[a],
[b]
) ON [PRIMARY]
GO
然后用shift和ctrl选中你想做主键的列,然后在点上面的那个小钥匙就成了,哈哈
create tableA
(
ID bigint identity(1,1),
name varchar(10) NOT NULL,
sex varchar(1) NOT NULL,
address varchar(60) NOT NULL,
primary key(name,address)
)
上面的表就是把name,address同做为一个主键!在企业管理器中:
按住ctrl键复选你要的字段,再按钥匙的图表,被选的字段前出现小钥匙也就你添加成功.
unique约束
用SQL语句:
create tableA
(
ID bigint identity(1,1),
name varchar(10) NOT NULL,
sex varchar(1) NOT NULL,
address varchar(60) NOT NULL,
unique(name,address)
)