After you create a partition function, the next step is to associate a partition scheme with the partition function. A partition scheme can be associated with only one partition function, but a partition function can be shared across multiple partition schemes.
The core function of a partition scheme is to map the values defined in the partition function to filegroups. When creating the statement for a partition scheme, you need to keep in mind the following:
A single filegroup can be used for all partitions, or a separate filegroup can be used for each individual partition.
Any filegroup referenced in the partition ...