-- create partition function
CREATE PARTITION FUNCTION partRange1 (INT)
AS RANGE LEFT FOR VALUES (10, 20, 30) ;
GO
-- create partition scheme
CREATE PARTITION SCHEME partScheme1
AS PARTITION partRange1
ALL TO ([PRIMARY]) ;
GO
-- create table that uses this partitioning scheme
CREATE TABLE partTable (col1 INT, col2 VARCHAR