alter database testdb add filegroup [filegroup1]

alter database testdb add file
(name=N‘file1‘, filename=N‘C:\db\data\file1.ndf‘, size=5MB, filegrowth=5MB)
to filegroup [filegroup1]

create partition function [func_order](orderId)
as range left for values(0, 1000, 2000)

create partition scheme [schema_order] as partition [func_order]
to ([PRIMARY], [filegroup1])

create table [dbo].[order](
　　 [orderId] bigint not null,
　　 [quantity] int
) on schema_order(orderId)

CREATE CLUSTERED INDEX [ClusteredIndex_on_schema_order] ON [dbo].[order] 
(
    [orderId]
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [func_order]([orderId])