添加和修改主鍵索引（多列聯(lián)合）
廣告：
創(chuàng)建：
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]
廣告：
