Table and Index Partitioning - Microsoft SQL Server 2012 Performance Tuning - page 308

If you have performed the previous recipe, Partitioning a table with
RANGE LEFT , you will find that the given script will also return the
details, as shown in following output screenshot, for the partition
function and its range values, as in the previous recipe.

5. After executing the previous query, you should see a result similar to the one shown

in the following screenshot:

6. Now, run the following script, which will create and verify the partition scheme

ps_OneMillion_RightRange based on the partition function pf_OneMillion_
RightRange that we just created:
USE Sample_DB
GO

--Creating Partition Scheme
CREATE PARTITION SCHEME ps_OneMillion_RightRange
AS PARTITION pf_OneMillion_RightRange
TO ([PRIMARY],[FG_1],[FG_2],[FG_3],[FG_N])

--Verify that the Partition Scheme
--has been created
SELECT
name
,data_space_id
,type
,type_desc
,function_id
FROM sys.partition_schemes
GO