GO
BEGIN TRANSACTION
CREATE PARTITION FUNCTION [PF_test](datetime) AS RANGE LEFT FOR VALUES (N'2020-12-31T23:59:59.997', N'2021-01-01T23:59:59.997', N'2021-01-02T23:59:59.997', N'2021-01-03T23:59:59.997', N'2021-01-04T23:59:59.997', N'2021-01-05T23:59:59.997')


CREATE PARTITION SCHEME [PS_test] AS PARTITION [PF_test] TO ([PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY])






ALTER TABLE [dbo].[test] DROP CONSTRAINT [PK_test] WITH ( ONLINE = OFF )


ALTER TABLE [dbo].[test] ADD  CONSTRAINT [PK_test] PRIMARY KEY CLUSTERED 
(
	[Time] ASC,
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PS_test]([Time])








COMMIT TRANSACTION