Partition Schema in SQL SERVER

This is needed for associating the partitions to a specific filegroups.

This is the second step in creating partitions.

The Syntax is as follows
CREATE PARTITION SCHEME  AS PARTITION < Partition Function Name > TO (< Filegroup1 >,< Filegroup2 >,….)

The example below shows the creation of the same

CREATE PARTITION SCHEME EmployeePartitionScheme AS PARTITION EmployeePartitionLeft TO ([EmployeePartitionFG1], [EmployeePartitionFG2], [PRIMARY])


The below example shows if all reside on the same filegroup
 
CREATE PARTITION SCHEME EmployeePartitionScheme  AS PARTITION EmployeePartitionLeft ALL TO (EmployeePartitionFG1)