27,582
社区成员




CREATE PARTITION FUNCTION [PF_TEST](int) AS RANGE RIGHT FOR VALUES (0,1000,2000)
GO
CREATE PARTITION SCHEME [PS_test] AS PARTITION [PF_test] TO ( [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY])
GO
create table tbtest (
id int not null
,PoNo varchar(20) not null
,data varchar(1000)
)
-- 按ID分区
ALTER TABLE [dbo].[tbtest] ADD CONSTRAINT [PK_tbtest] PRIMARY KEY CLUSTERED
(
[id] ASC
) ON [PS_test]([id])
GO
-- 唯一索引不建立到分区
create UNIQUE index UQ_test on tbtest(pono) ON [PRIMARY]
GO