CREATE TABLE [dbo].[H1_Serv02](
[HID] [uniqueidentifier] NOT NULL DEFAULT newid(),
[Col] [bigint] NOT NULL,
[ClassID] [bigint] NULL,
CONSTRAINT [PK_H2] PRIMARY KEY CLUSTERED
(
[HID] ASC,
[Col] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [col_scheme]([Col])
) ON [col_scheme]([Col])
[HID] [uniqueidentifier] NOT NULL DEFAULT newid(),
[Col] [bigint] NOT NULL,
[ClassID] [bigint] NULL,
CONSTRAINT [PK_H2] PRIMARY KEY CLUSTERED
(
[HID] ASC,
[Col] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [col_scheme]([Col])
) ON [col_scheme]([Col])
因为分区的依据列必须为主键的一部分,所以Col需要制定主键,
怎么指定hid为主键呢?