ALTER PARTITION FUNCTION [anonyuserFun](int) {SPLIT RANGE {boundary_value}}
模仿修改就可以了: CREATE PARTITION FUNCTION myRangePF1 (int) AS RANGE LEFT FOR VALUES (1, 100, 1000); GO CREATE PARTITION SCHEME myRangePS1 AS PARTITION myRangePF1 TO (test1fg, test2fg, test3fg, test4fg); --test1fg, test2fg, test3fg, test4fg is filegroup name
{SPLIT RANGE {boundary_value}}
CREATE PARTITION FUNCTION myRangePF1 (int)
AS RANGE LEFT FOR VALUES (1, 100, 1000);
GO
CREATE PARTITION SCHEME myRangePS1
AS PARTITION myRangePF1
TO (test1fg, test2fg, test3fg, test4fg);
--test1fg, test2fg, test3fg, test4fg is filegroup name