添加和修改主键索引（多列联合）

广告：

创建：

CREATE TABLE [PaGamePrivate].[TblProgressChallenge](
[_registerDate] [datetime] NULL,
[_userNo] [bigint] NOT NULL,
[_challengeKey] [int] NOT NULL,
[_paramNumber] [int] NOT NULL,
[_paramTime] [bigint] NOT NULL,
CONSTRAINT [PkTblProgressChallenge] PRIMARY KEY NONCLUSTERED
(
[_userNo] ASC,
[_challengeKey] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

修改：

alter TABLE [PaGamePrivate].[TblProgressChallenge] add
CONSTRAINT [PkTblProgressChallenge] PRIMARY KEY NONCLUSTERED(

[_userNo] ASC,
[_challengeKey] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]

以下删除：) ON [PRIMARY]

广告：