34,873
社区成员
发帖
与我相关
我的任务
分享如何在SQL中建立主关键字
如:
CREATE TABLE [dbo].[department] (
[Department_id] [smallint] NOT NULL ,
[Department_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
我要把Department_id设为主关键字,请问怎么建?
CREATE TABLE [dbo].[department] (
[Department_id] [smallint] NOT NULL ,
[Department_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
我要把Department_id设为主关键字,请问怎么建?
...全文
请发表友善的回复…
发表回复
HawaiiLeo 2003-05-25
- 打赏
- 举报
CREATE TABLE [dbo].[department] (
[Department_id] [smallint] NOT NULL PRIMARY KEY CLUSTERED,
[Department_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
[Department_id] [smallint] NOT NULL PRIMARY KEY CLUSTERED,
[Department_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
Jaron 2003-05-25
- 打赏
- 举报
ALTER TABLE [dbo].[department] WITH NOCHECK ADD
CONSTRAINT [PK_department] PRIMARY KEY CLUSTERED
(
[Department_id]
) ON [PRIMARY]
GO
CONSTRAINT [PK_department] PRIMARY KEY CLUSTERED
(
[Department_id]
) ON [PRIMARY]
GO
